DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_PLANS

Line 2653: FROM msc_plans plans,

2649: l_plan_info_rec.plan_type,
2650: x_plan_info_rec.itf_horiz_days,
2651: l_plan_info_rec.itf_horiz_days
2652: -- ATP4drp changes end
2653: FROM msc_plans plans,
2654: msc_plans plans2
2655: WHERE plans.plan_id = x_plan_info_rec.plan_id
2656: AND plans.plan_completion_date is not null
2657: AND plans.data_completion_date is not null

Line 2654: msc_plans plans2

2650: x_plan_info_rec.itf_horiz_days,
2651: l_plan_info_rec.itf_horiz_days
2652: -- ATP4drp changes end
2653: FROM msc_plans plans,
2654: msc_plans plans2
2655: WHERE plans.plan_id = x_plan_info_rec.plan_id
2656: AND plans.plan_completion_date is not null
2657: AND plans.data_completion_date is not null
2658: and plans.plan_id = plans2.copy_plan_id (+);

Line 4887: FROM msc_plans

4883: -- at org default.
4884:
4885: SELECT curr_cutoff_date
4886: INTO l_infinite_time_fence_date
4887: FROM msc_plans
4888: WHERE plan_id = p_plan_id;
4889:
4890: IF PG_DEBUG in ('Y', 'C') THEN
4891: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);