APPS.HXT_TIM_COL_UTIL dependencies on HR_LOCATIONS
Line 270: FROM hr_locations
266: BEGIN
267:
268: SELECT location_id
269: INTO o_location_id 270: FROM hr_locations 271: WHERE location_code = i_location_code
272: AND COUNTRY = 'US'
273: AND i_date_worked <= NVL(INACTIVE_DATE, i_date_worked);
274: