DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on HR_LOCATIONS_ALL_TL

Line 2982: hr_locations_all_tl lot

2978: begin
2979: select loc.location_id
2980: into l_location_id
2981: from hr_locations_all loc,
2982: hr_locations_all_tl lot
2983: where lot.location_code = p_location_code
2984: and lot.language = p_language_code
2985: and lot.location_id = loc.location_id
2986: and (loc.business_group_id is null or

Line 3031: hr_locations_all_tl lot

3027: begin
3028: select loc.location_id
3029: into l_location_id
3030: from hr_locations_all loc,
3031: hr_locations_all_tl lot
3032: where lot.location_code = p_ship_to_location_code
3033: and lot.language = p_language_code
3034: and lot.location_id = loc.location_id
3035: and (loc.business_group_id is null or