APPS.MSD_EOL_PLAN dependencies on MSC_PLANS

Line 41: from msc_plans

37: IS
38: CURSOR c_plan_start_date
39: is
40: select plan_start_date
41: from msc_plans
42: where
43: plan_id = p_plan_id ;
44:
45: x_plan_start_date DATE ;

Line 411: from msc_plans mp, msd_demand_plans mdp

407: where mdp.demand_plan_id=p_demand_plan_id
408: and mdp.parameter_type=par.parameter_type);
409:
410: select mp.compile_designator into l_supply_plan_name
411: from msc_plans mp, msd_demand_plans mdp
412: where mp.plan_id=mdp.liab_plan_id
413: and mdp.demand_plan_id=p_demand_plan_id;
414:
415: else

Line 533: from msc_plans mp, msd_demand_plans mdp

529: end if;
530:
531:
532: select mp.compile_designator into l_supply_plan_name
533: from msc_plans mp, msd_demand_plans mdp
534: where mp.plan_id=mdp.liab_plan_id
535: and mdp.demand_plan_id=p_demand_plan_id;
536:
537: