107: where wsh_location_id = v_location_id;
108:
109: CURSOR c_hr_locs (v_location_id NUMBER) IS
110: SELECT b.location_code
111: FROM hr_locations_all a,
112: hr_locations_all_tl b
113: WHERE a.location_id = v_location_id
114: AND a.location_id = b.location_id
115: AND b.language=USERENV('LANG');
108:
109: CURSOR c_hr_locs (v_location_id NUMBER) IS
110: SELECT b.location_code
111: FROM hr_locations_all a,
112: hr_locations_all_tl b
113: WHERE a.location_id = v_location_id
114: AND a.location_id = b.location_id
115: AND b.language=USERENV('LANG');
116: