APPS.HR_PUMP_GET dependencies on HR_LOCATIONS_ALL

Line 2954: from hr_locations_all loc,

2950: l_location_id number;
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

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 3003: from hr_locations_all loc,

2999: l_location_id number;
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

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

Line 3971: -- Changed to use hr_locations_all for WWBUG 1833930.

3967: ) return number is
3968: l_ovn number;
3969: begin
3970: --
3971: -- Changed to use hr_locations_all for WWBUG 1833930.
3972: --
3973: select loc.object_version_number
3974: into l_ovn
3975: from hr_locations_all loc

Line 3975: from hr_locations_all loc

3971: -- Changed to use hr_locations_all for WWBUG 1833930.
3972: --
3973: select loc.object_version_number
3974: into l_ovn
3975: from hr_locations_all loc
3976: where loc.location_code = p_location_code;
3977: return(l_ovn);
3978: exception
3979: when others then