DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_PLAN_BUCKETS

Line 143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd

139: IS
140: CURSOR c1(p_plan_id NUMBER) IS
141: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
142: mpsd.period_start_date, mpb.bucket_type
143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
144: WHERE mp.plan_id = p_plan_id
145: AND mtp.sr_tp_id = mp.organization_id
146: AND mtp.sr_instance_id = mp.sr_instance_id
147: AND mtp.partner_type = 3