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
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