DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_PKG dependencies on MSC_PERIOD_START_DATES

Line 210: msc_period_start_dates mpsd,

206: CURSOR totalMfgPerCur(p_plan_id in NUMBER, p_sr_instance_id in number, p_org_id in number)
207: IS
208: SELECT count(distinct mpsd.period_start_date)
209: FROM msc_trading_partners tp,
210: msc_period_start_dates mpsd,
211: msc_plans mp
212: WHERE mpsd.calendar_code = tp.calendar_code
213: and mpsd.sr_instance_id = tp.sr_instance_id
214: and mpsd.exception_set_id = tp.calendar_exception_set_id