[Home] [Help]
112:
113: CURSOR week_bucket IS
114: SELECT to_char(mpsd.week_start_date,'DD-MM-RR'), mpsd.week_start_date
115: FROM msc_trading_partners tp,
116: msc_cal_week_start_dates mpsd,
117: msc_plans mp
118: WHERE mpsd.calendar_code = tp.calendar_code
119: and mpsd.sr_instance_id = tp.sr_instance_id
120: and mpsd.exception_set_id = tp.calendar_exception_set_id