[Home] [Help]
81: md.seq_num,
82: b.bucket_type,
83: b.bucket_index
84: from
85: msc_plan_buckets b,
86: msc_calendar_dates md
87: where b.plan_id=p_plan_id
88: and b.curr_flag=1
89: and md.calendar_code=l_calendar_code
94: mw.week_start_date,
95: mw.next_date-1 week_end_date,
96: max(decode(md.seq_num, null, null, md.calendar_date)) week_last_work_date
97: from
98: msc_plan_buckets b,
99: msc_calendar_dates md,
100: msc_cal_week_start_dates mw
101: where b.plan_id=p_plan_id
102: and b.curr_flag=1
116: mp.period_start_date,
117: mp.next_date-1 period_end_date,
118: max(decode(md.seq_num, null, null, md.calendar_date)) period_last_work_date
119: from
120: msc_plan_buckets b,
121: msc_calendar_dates md,
122: msc_period_start_dates mp
123: where b.plan_id=p_plan_id
124: and b.curr_flag=1
138: and w.week_start_date between p.period_start_date and p.period_end_date
139: ),
140: m as (
141: select bkt_start_date plan_start_date
142: from msc_plan_buckets
143: where plan_id=p_plan_id
144: and curr_flag=1
145: and bucket_index=1
146: )