348:
349: -- get supply plans that are attached to a demand plan
350: cursor c_plans(dp_id number) IS
351: select SUPPLY_PLAN_ID,SUPPLY_PLAN_NAME 352: from msd_dp_scenarios 353: where demand_plan_id = dp_id
354: and supply_plan_id is not null;
355:
356: BEGIN