249: SET /* dates.last_update_date = SYSDATE,
250: dates.last_updated_by = user_id, */
251: dates.forecast_date =
252: (SELECT MAX(week_start_date)
253: FROM bom_cal_week_start_dates cal
254: WHERE cal.calendar_code = cal_code
255: AND cal.exception_set_id = except_set_id
256: AND cal.week_start_date <= dates.forecast_date)
257: WHERE dates.bucket_type = 2
264: SET /* dates.last_update_date = SYSDATE,
265: dates.last_updated_by = user_id, */
266: dates.rate_end_date =
267: (SELECT MAX(week_start_date)
268: FROM bom_cal_week_start_dates cal
269: WHERE cal.calendar_code = cal_code
270: AND cal.exception_set_id = except_set_id
271: AND cal.week_start_date <= dates.rate_end_date)
272: WHERE dates.rate_end_date IS NOT NULL