544: ,hoi2.ORG_INFORMATION3 AMB_RC
545: ,hoi2.ORG_INFORMATION4 SP_RC
546: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
547: FROM HR_ORGANIZATION_UNITS hou
548: , HR_ORGANIZATION_INFORMATION hoi1
549: , HR_ORGANIZATION_INFORMATION hoi2
550: WHERE hou.business_group_id = p_business_group_id
551: and hoi1.organization_id = hou.organization_id
552: and hoi1.organization_id = p_business_group_id
545: ,hoi2.ORG_INFORMATION4 SP_RC
546: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
547: FROM HR_ORGANIZATION_UNITS hou
548: , HR_ORGANIZATION_INFORMATION hoi1
549: , HR_ORGANIZATION_INFORMATION hoi2
550: WHERE hou.business_group_id = p_business_group_id
551: and hoi1.organization_id = hou.organization_id
552: and hoi1.organization_id = p_business_group_id
553: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'