DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_PERIOD_START_DATES

Line 3576: msc_period_start_dates mpsd,

3572: -- fetch period start date
3573: SELECT greatest(mpsd.period_start_date, mp.data_start_date)
3574: BULK COLLECT INTO v_date
3575: FROM msc_trading_partners tp,
3576: msc_period_start_dates mpsd,
3577: msc_plans mp
3578: WHERE mpsd.calendar_code = tp.calendar_code
3579: and mpsd.sr_instance_id = tp.sr_instance_id
3580: and mpsd.exception_set_id = tp.calendar_exception_set_id