APPS.MSD_LIABILITY dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 423: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,

419: /* If there is a change of profile in two consecutive run the program will give a warning */
420: /* If the profile value is null then a warning will be given and the output level will be defaulted to Item */
421:
422: select mdsol.LEVEL_ID , mds.scenario_id into x_prev_liab_calc_level , x_scenario_id from
423: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,
424: msd_dp_scenarios mds
425: where
426: mds.demand_plan_id = mdsol.demand_plan_id and
427: mds.scenario_id = mdsol.scenario_id

Line 435: update MSD_DP_SCENARIO_OUTPUT_LEVELS

431:
432:
433: IF x_liab_calc_level is not null THEN
434: /* update the output level of the scenario */
435: update MSD_DP_SCENARIO_OUTPUT_LEVELS
436: set level_id = x_liab_calc_level
437: where level_id = x_prev_liab_calc_level
438: and demand_plan_id = x_liab_plan_id
439: and scenario_id = x_scenario_id ;

Line 458: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,

454:
455:
456: ELSE
457: select mdsol.LEVEL_ID , mds.scenario_id into x_prev_liab_calc_level , x_scenario_id from
458: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,
459: msd_dp_scenarios mds
460: where
461: mds.demand_plan_id = mdsol.demand_plan_id and
462: mds.scenario_id = mdsol.scenario_id

Line 471: update MSD_DP_SCENARIO_OUTPUT_LEVELS

467:
468:
469: IF x_liab_calc_level is not null THEN
470: /* update the output level of the scenario */
471: update MSD_DP_SCENARIO_OUTPUT_LEVELS
472: set level_id = x_liab_calc_level
473: where level_id = x_prev_liab_calc_level
474: and demand_plan_id = x_liab_plan_id
475: and scenario_id = x_scenario_id ;

Line 2234: msd_dp_scenario_output_levels a,

2230: IS
2231: CURSOR get_dup_dim_output_levels IS
2232: SELECT scen.scenario_name,ml.dimension_code,count(*)
2233: FROM
2234: msd_dp_scenario_output_levels a,
2235: msd_levels ml,
2236: msd_dp_scenarios scen,
2237: msd_demand_plans mdp
2238: WHERE a.level_id = ml.level_id