803: ,hoi2.ORG_INFORMATION3 AMB_RC
804: ,hoi2.ORG_INFORMATION4 SP_RC
805: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
806: FROM HR_ORGANIZATION_UNITS hou
807: , HR_ORGANIZATION_INFORMATION hoi1
808: , HR_ORGANIZATION_INFORMATION hoi2
809: WHERE hou.business_group_id = p_business_group_id
810: and hoi1.organization_id = hou.organization_id
811: and hoi1.organization_id = p_business_group_id
804: ,hoi2.ORG_INFORMATION4 SP_RC
805: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
806: FROM HR_ORGANIZATION_UNITS hou
807: , HR_ORGANIZATION_INFORMATION hoi1
808: , HR_ORGANIZATION_INFORMATION hoi2
809: WHERE hou.business_group_id = p_business_group_id
810: and hoi1.organization_id = hou.organization_id
811: and hoi1.organization_id = p_business_group_id
812: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'