DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on HR_LOCATIONS_ALL

Line 115: FROM hr_locations_all a,

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');

Line 116: hr_locations_all_tl b

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: