APPS.OTA_TIMEZONE_UPGRADE dependencies on HR_LOCATIONS

Line 29: FROM hr_locations

25: l_time_zone ota_events.timezone%TYPE;
26:
27: CURSOR csr_loc_tz(loc_id NUMBER) IS
28: SELECT timezone_code
29: FROM hr_locations
30: WHERE location_id = loc_id;
31: BEGIN
32:
33: OPEN csr_loc_tz(l_location_id);

Line 237: hr_locations loc

233:
234: CURSOR csr_pri_ven_tz(p_pri_ven NUMBER) IS
235: SELECT loc.timezone_code
236: FROM ota_suppliable_resources res,
237: hr_locations loc
238: WHERE supplied_resource_id = p_pri_ven
239: AND res.location_id = loc.location_id;
240: BEGIN
241:

Line 264: FROM hr_locations loc,

260:
261: CURSOR csr_trgctr_tz(trg_cen_id NUMBER) IS
262: SELECT loc.timezone_code
263:
264: FROM hr_locations loc,
265: hr_all_organization_units org
266: WHERE loc.location_id = org.location_id
267: AND org.organization_id = trg_cen_id;
268: BEGIN