eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EMPDIR_SS dependencies on HR_LOCATIONS_ALL_TL

Line 2675: FROM hr_locations_all_tl ltl, hr_locations_all l

2671: g_srcSystem, ltl.location_id, ltl.location_code, ltl.description,
2672: ltl.language, ltl.source_lang, l.object_version_number, 1,
2673: g_date, g_user_id, g_user_id, g_date, g_request_id,
2674: g_prog_appl_id, g_prog_id, g_date
2675: FROM hr_locations_all_tl ltl, hr_locations_all l
2676: WHERE ltl.location_id = l.location_id
2677: AND ltl.language = loc.language
2678: AND ltl.location_id = loc.orig_system_id
2679: AND loc.orig_system = g_srcSystem)

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

2722: g_request_id,
2723: g_prog_appl_id,
2724: g_prog_id,
2725: g_date
2726: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel
2727: WHERE ltl.location_id = l.location_id
2728: AND pel.orig_system_id = l.location_id
2729: AND pel.orig_system = g_srcSystem
2730: AND NOT EXISTS (SELECT 'e' from per_empdir_locations_tl il

Line 3307: from hr_locations_all_tl ltl, hr_locations_all l

3303: g_request_id,
3304: g_prog_appl_id,
3305: g_prog_id,
3306: g_date
3307: from hr_locations_all_tl ltl, hr_locations_all l
3308: where ltl.location_id = l.location_id;
3309:
3310: l_cnt := sql%rowcount;
3311: COMMIT;