APPS.HXT_TIME_GEN dependencies on HXT_HOLIDAY_DAYS

Line 1436: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy

1432: CURSOR cur_hcl (c_date DATE, c_hcl_id NUMBER)
1433: IS
1434: -- SELECT hcl.element_type_id, hdy.hours -- SPR C332 by BC
1435: SELECT DECODE (hdy.hours, NULL, NULL, hcl.element_type_id), hdy.hours -- SPR C332 by BC
1436: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy
1437: WHERE hdy.holiday_date = c_date
1438: AND hcl.id = hdy.hcl_id
1439: AND c_date BETWEEN hcl.effective_start_date
1440: AND hcl.effective_end_date