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