412: -- Define cursor to return any holiday that falls between
413: -- the day before and the day after the date passed
414: CURSOR holiday_cur IS
415: select hdy.id, hdy.hours, hdy.holiday_date 416: from hxt_holiday_days hdy 417: ,hxt_holiday_calendars hcl
418: where hdy.holiday_date between p_date - 1 and p_date + 1
419: and hdy.hcl_id = hcl.id
420: and p_date between hcl.effective_start_date
[Home] [Help]