APPS.HXT_TIME_GEN dependencies on HXT_HOLIDAY_CALENDARS

Line 1584: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy

1580: CURSOR cur_hcl (c_date DATE, c_hcl_id NUMBER)
1581: IS
1582: -- SELECT hcl.element_type_id, hdy.hours -- SPR C332 by BC
1583: SELECT DECODE (hdy.hours, NULL, NULL, hcl.element_type_id), hdy.hours -- SPR C332 by BC
1584: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy
1585: WHERE hdy.holiday_date = c_date
1586: AND hcl.id = hdy.hcl_id
1587: AND c_date BETWEEN hcl.effective_start_date
1588: AND hcl.effective_end_date