DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_HOLIDAY_CALENDARS

Line 888: FROM hxt_holiday_calendars hcl,

884: CURSOR l_hol_cur( c_start_date DATE, c_end_date DATE, c_hcl_id NUMBER) IS
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