416: -- Define cursor to return any holiday that falls between
417: -- the day before and the day after the date passed
418: CURSOR holiday_cur IS
419: select hdy.id, hdy.hours, hdy.holiday_date 420: from hxt_holiday_days hdy 421: ,hxt_holiday_calendars hcl
422: where hdy.holiday_date between p_date - 1 and p_date + 1
423: and hdy.hcl_id = hcl.id
424: and p_date between hcl.effective_start_date