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

Line 719: ' FROM hr_locations_all l';

715: ' per_empdir_SS.get_timezone_code(postal_code, town_or_city,' ||
716: ' decode(country,''US'',region_2,region_1), country))' ||
717: ' ,object_version_number' ||
718: ' ,1 ' ||
719: ' FROM hr_locations_all l';
720: IF (p_mode = 0) THEN
721: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
722: query_str := query_str || ' WHERE label_to_char(HR_ENTERPRISE) <> ''C::ENT''';
723: END IF;

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 2675: WHERE EXISTS (SELECT 'e' FROM hr_locations_all ol

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)
2675: WHERE EXISTS (SELECT 'e' FROM hr_locations_all ol
2676: WHERE loc.object_version_number <> ol.object_version_number
2677: AND loc.orig_system_id = ol.location_id
2678: AND loc.orig_system = g_srcSystem)
2679: 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;