APPS.HR_PUMP_GET dependencies on HR_LOCATIONS_ALL

Line 2981: from hr_locations_all loc,

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

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

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

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

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

3994: ) return number is
3995: l_ovn number;
3996: begin
3997: --
3998: -- Changed to use hr_locations_all for WWBUG 1833930.
3999: --
4000: select loc.object_version_number
4001: into l_ovn
4002: from hr_locations_all loc

Line 4002: from hr_locations_all loc

3998: -- Changed to use hr_locations_all for WWBUG 1833930.
3999: --
4000: select loc.object_version_number
4001: into l_ovn
4002: from hr_locations_all loc
4003: where loc.location_code = p_location_code;
4004: return(l_ovn);
4005: exception
4006: when others then