APPS.HXT_TIME_CLOCK dependencies on HXT_HOLIDAY_DAYS

Line 889: hxt_holiday_days hdy

885: SELECT hcl.element_type_id,
886: hdy.hours,
887: hdy.holiday_date
888: FROM hxt_holiday_calendars hcl,
889: hxt_holiday_days hdy
890: WHERE TRUNC(hdy.holiday_date,'DD') BETWEEN TRUNC(c_start_date,'DD') AND TRUNC(c_end_date,'DD')
891: AND hcl.id = hdy.hcl_id
892: AND hdy.holiday_date BETWEEN hcl.effective_start_date AND hcl.effective_end_date
893: AND hcl.id = c_hcl_id;