DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on HR_LOCATIONS_ALL_TL

Line 2955: hr_locations_all_tl lot

2951: begin
2952: select loc.location_id
2953: into l_location_id
2954: from hr_locations_all loc,
2955: hr_locations_all_tl lot
2956: where lot.location_code = p_location_code
2957: and lot.language = p_language_code
2958: and lot.location_id = loc.location_id
2959: and (loc.business_group_id is null or

Line 3004: hr_locations_all_tl lot

3000: begin
3001: select loc.location_id
3002: into l_location_id
3003: from hr_locations_all loc,
3004: hr_locations_all_tl lot
3005: where lot.location_code = p_ship_to_location_code
3006: and lot.language = p_language_code
3007: and lot.location_id = loc.location_id
3008: and (loc.business_group_id is null or