Oracle Apps HRMS Organization classification and Types

Organization classification and type information

SELECT HAOU.NAME,HOI.ORG_INFORMATION1,HOI.ORG_INFORMATION_CONTEXT,HOIT.DISPLAYED_ORG_INFORMATION_TYPE
FROM HR_ORGANIZATION_INFORMATION HOI, HR_ALL_ORGANIZATION_UNITS HAOU,HR_ORG_INFORMATION_TYPES HOIT
WHERE HOI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
-- AND HOI.ORG_INFORMATION1 = 'HR_BG'
AND HOIT.ORG_INFORMATION_TYPE = HOI.ORG_INFORMATION_CONTEXT