APPS.PER_EMPDIR_SS dependencies on HR_LOCATIONS_ALL

Line 722: ' FROM hr_locations_all l';

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

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

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)
2680: WHERE EXISTS (SELECT 'e' FROM hr_locations_all ol
2681: WHERE loc.object_version_number <> ol.object_version_number
2682: AND loc.orig_system_id = ol.location_id
2683: AND loc.orig_system = g_srcSystem)
2684: 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;