DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_PLAN_BUCKETS

Line 68: from msc_plan_buckets

64:
65:
66: select min(bkt_start_date), max(bkt_end_date)
67: into l_first_bkt_start_date, l_last_bkt_end_date
68: from msc_plan_buckets
69: where plan_id=p_plan_id;
70:
71: l_api_name := 'msc_item_f_pkg.populate_summaries';
72:

Line 199: from msc_plan_buckets mpb,

195: mpb.bkt_start_date) working_day_bkt_start_date,
196:
197: mpb.bucket_type,
198: mpb.days_in_bkt
199: from msc_plan_buckets mpb,
200: msc_plans mp
201: where mpb.plan_id =p_plan_id
202: and mp.plan_id=mpb.plan_id
203: and mpb.sr_instance_id = mp.sr_instance_id