APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 2442: from msd_dp_scenario_output_levels

2438: cursor c4(p_plan_type in varchar2, p_dimension_code in varchar2) is
2439:
2440: select level_id
2441:
2442: from msd_dp_scenario_output_levels
2443:
2444: where demand_plan_id = p_new_dp_id
2445:
2446: and level_id in

Line 4734: from msd_dp_scenario_output_levels

4730: cursor c1 is
4731:
4732: select enable_nonseed_flag
4733:
4734: from msd_dp_scenario_output_levels
4735:
4736: where demand_plan_id = p_demand_plan_id
4737:
4738: and scenario_id = p_scenario_id

Line 5583: insert into msd_dp_scenario_output_levels

5579:
5580:
5581:
5582:
5583: insert into msd_dp_scenario_output_levels
5584:
5585: (
5586:
5587: demand_plan_id

Line 5637: from msd_dp_scenario_output_levels

5633: ,NULL
5634:
5635: ,SYSDATE
5636:
5637: from msd_dp_scenario_output_levels
5638:
5639: where scenario_id = c2_cur.scenario_id
5640:
5641: and demand_plan_id = c2_cur.demand_plan_id);

Line 8003: insert into msd_dp_scenario_output_levels

7999: from msd_dp_scenario_events
8000: where scenario_id = c2_rec.scenario_id
8001: and demand_plan_id = c2_rec.demand_plan_id);
8002:
8003: insert into msd_dp_scenario_output_levels
8004: (
8005: demand_plan_id
8006: ,scenario_id
8007: ,level_id

Line 8030: from msd_dp_scenario_output_levels

8026: ,NULL
8027: ,NULL
8028: ,NULL
8029: ,SYSDATE
8030: from msd_dp_scenario_output_levels
8031: where scenario_id = c2_rec.scenario_id
8032: and demand_plan_id = c2_rec.demand_plan_id);
8033:
8034: end loop;