75: BEGIN
76: IF (x_bucket = G_WEEKS) THEN
77: SELECT count(week_start_date)
78: INTO l_buckets
79: FROM bom_cal_week_start_dates cal
80: WHERE cal.exception_set_id = x_exception_set_id
81: AND cal.calendar_code = x_calendar_code
82: AND cal.week_start_date between x_start_date
83: and x_end_date;
148:
149: CURSOR GetLastDay IS
150: SELECT decode(next_date, week_start_date,
151: x_last_calendar_date, (next_date -1)) last_day
152: FROM bom_cal_week_start_dates
153: WHERE calendar_code = x_calendar_code
154: AND exception_set_id = x_exception_set_id
155: AND week_start_date = nvl(x_rate_end_date, x_forecast_date);
156: BEGIN