APPS.PER_EMPDIR_SS dependencies on HR_LOCATIONS_ALL_TL

Line 2670: FROM hr_locations_all_tl ltl, hr_locations_all l

2666: g_srcSystem, ltl.location_id, ltl.location_code, ltl.description,
2667: ltl.language, ltl.source_lang, l.object_version_number, 1,
2668: g_date, g_user_id, g_user_id, g_date, g_request_id,
2669: g_prog_appl_id, g_prog_id, g_date
2670: FROM hr_locations_all_tl ltl, hr_locations_all l
2671: WHERE ltl.location_id = l.location_id
2672: AND ltl.language = loc.language
2673: AND ltl.location_id = loc.orig_system_id
2674: AND loc.orig_system = g_srcSystem)

Line 2721: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel

2717: g_request_id,
2718: g_prog_appl_id,
2719: g_prog_id,
2720: g_date
2721: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel
2722: WHERE ltl.location_id = l.location_id
2723: AND pel.orig_system_id = l.location_id
2724: AND pel.orig_system = g_srcSystem
2725: AND NOT EXISTS (SELECT 'e' from per_empdir_locations_tl il

Line 3301: from hr_locations_all_tl ltl, hr_locations_all l

3297: g_request_id,
3298: g_prog_appl_id,
3299: g_prog_id,
3300: g_date
3301: from hr_locations_all_tl ltl, hr_locations_all l
3302: where ltl.location_id = l.location_id;
3303:
3304: l_cnt := sql%rowcount;
3305: COMMIT;