DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_BIS_PERIODS

Line 101: msc_plans mp, msc_bis_periods mbp

97: (SELECT DISTINCT mbid.detail_date
98: FROM msc_bis_inv_detail mbid
99: WHERE mbid.plan_id = p_Plan_id
100: AND (mbid.period_type IS NULL OR mbid.period_type = 0)) pd,
101: msc_plans mp, msc_bis_periods mbp
102: WHERE mp.plan_id = p_plan_id
103: AND mp.sr_instance_id = mbp.sr_instance_id
104: AND mp.organization_id = mbp.organization_id
105: AND mbp.period_set_name = 'Accounting'