DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_PLANS

Line 295: FROM msc_plans

291: END IF;
292:
293: SELECT curr_cutoff_date
294: INTO l_infinite_time_fence_date
295: FROM msc_plans
296: WHERE plan_id = p_plan_id;
297: IF PG_DEBUG in ('Y', 'C') THEN
298: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);
299: END IF;

Line 408: FROM msc_plans

404: -- at org default.
405:
406: SELECT trunc(curr_cutoff_date)
407: INTO l_infinite_time_fence_date
408: FROM msc_plans
409: WHERE plan_id = p_plan_id;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN
412: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);