DBA Data[Home] [Help]

APPS.HR_SE_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 383: FROM hr_organization_units o1

379: ) RETURN NUMBER IS
380:
381: CURSOR c_get_details(p_business_group_id NUMBER , p_tax_unit_id NUMBER, p_effective_date DATE) IS
382: SELECT hoi2.org_information1,hoi2.org_information2,hoi2.org_information3
383: FROM hr_organization_units o1
384: , hr_organization_information hoi1
385: , hr_organization_information hoi2
386: WHERE o1.business_group_id = p_business_group_id
387: AND hoi1.organization_id = o1.organization_id