DBA Data[Home] [Help]

APPS.HR_SE_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 428: FROM hr_organization_units o1

424: ) RETURN NUMBER IS
425:
426: CURSOR c_get_details(p_business_group_id NUMBER , p_tax_unit_id NUMBER, p_effective_date DATE) IS
427: SELECT hoi2.org_information1,hoi2.org_information2,hoi2.org_information3
428: FROM hr_organization_units o1
429: , hr_organization_information hoi1
430: , hr_organization_information hoi2
431: WHERE o1.business_group_id = p_business_group_id
432: AND hoi1.organization_id = o1.organization_id