APPS.PAY_US_RULES dependencies on HR_ALL_ORGANIZATION_UNITS
Line 2640: hr_all_organization_units org,
2636: CURSOR get_employer_name_phone ( cp_organization_id in number) IS
2637: SELECT
2638: org.NAME,loc.telephone_number_1
2639: FROM 2640: hr_all_organization_units org, 2641: hr_locations_all loc
2642: WHERE
2643: org.location_id=loc.location_id
2644: AND org.organization_id = cp_organization_id;