APPS.HXT_TIME_SUMMARY dependencies on HXT_HOLIDAY_DAYS

Line 621: hxt_holiday_days hhd

617: p_date_worked IN DATE,
618: p_hol_id IN NUMBER)
619: IS SELECT 1
620: FROM hxt_sum_hours_worked sum,
621: hxt_holiday_days hhd
622: WHERE tim_id = p_tim_id
623: AND sum.date_worked > p_date_worked
624: AND hhd.hcl_id = p_hol_id
625: AND sum.date_worked = hhd.holiday_date;

Line 723: FROM hxt_holiday_days

719: -- Added the exception block below.
720: BEGIN
721: SELECT 1
722: INTO l_hol_true
723: FROM hxt_holiday_days
724: WHERE hcl_id = g_hol_hol_id
725: AND holiday_date = g_hol_date_worked;
726:
727: EXCEPTION