[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'