DBA Data[Home] [Help]

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;