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