APPS.HXT_TIMECARD_INFO dependencies on HXT_HOLIDAY_CALENDARS

Line 1037: FROM hxt_holiday_calendars hcl, hxt_holiday_days hhd

1033:
1034: CURSOR cur_hcl (p_date DATE, p_hcl_id NUMBER)
1035: IS
1036: SELECT DECODE (hhd.hours, NULL, NULL, hcl.element_type_id), hhd.hours
1037: FROM hxt_holiday_calendars hcl, hxt_holiday_days hhd
1038: WHERE hhd.holiday_date = p_date
1039: AND hcl.id = hhd.hcl_id
1040: AND p_date BETWEEN hcl.effective_start_date
1041: AND hcl.effective_end_date