DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_PLANS

Line 2662: FROM msc_plans plans,

2658: l_plan_info_rec.plan_type,
2659: x_plan_info_rec.itf_horiz_days,
2660: l_plan_info_rec.itf_horiz_days
2661: -- ATP4drp changes end
2662: FROM msc_plans plans,
2663: msc_plans plans2
2664: WHERE plans.plan_id = x_plan_info_rec.plan_id
2665: AND plans.plan_completion_date is not null
2666: AND plans.data_completion_date is not null

Line 2663: msc_plans plans2

2659: x_plan_info_rec.itf_horiz_days,
2660: l_plan_info_rec.itf_horiz_days
2661: -- ATP4drp changes end
2662: FROM msc_plans plans,
2663: msc_plans plans2
2664: WHERE plans.plan_id = x_plan_info_rec.plan_id
2665: AND plans.plan_completion_date is not null
2666: AND plans.data_completion_date is not null
2667: and plans.plan_id = plans2.copy_plan_id (+);

Line 4896: FROM msc_plans

4892: -- at org default.
4893:
4894: SELECT curr_cutoff_date
4895: INTO l_infinite_time_fence_date
4896: FROM msc_plans
4897: WHERE plan_id = p_plan_id;
4898:
4899: IF PG_DEBUG in ('Y', 'C') THEN
4900: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);