APPS.PER_US_EXTRA_REHIRE_RULES dependencies on PER_PERIODS_OF_SERVICE

Line 10: per_periods_of_service pds

6: --
7: CURSOR csr_get_address_id (p_pds_id NUMBER) IS
8: SELECT adr.address_id
9: FROM per_addresses adr,
10: per_periods_of_service pds
11: WHERE pds.period_of_service_id = p_pds_id
12: AND adr.primary_flag = 'Y'
13: AND adr.person_id = pds.person_id;
14: