APPS.HXT_TIME_COLLECTION dependencies on HXT_HOLIDAY_CALENDARS

Line 102: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy

98:
99: CURSOR g_hol_cur (c_start_date DATE, c_end_date DATE, c_hcl_id NUMBER)
100: IS
101: SELECT hcl.element_type_id, hdy.hours, hdy.holiday_date
102: FROM hxt_holiday_calendars hcl, hxt_holiday_days hdy
103: WHERE TRUNC (hdy.holiday_date, 'DD') BETWEEN TRUNC (c_start_date, 'DD')
104: AND TRUNC (c_end_date, 'DD')
105: AND hcl.id = hdy.hcl_id
106: AND hdy.holiday_date BETWEEN hcl.effective_start_date