DBA Data[Home] [Help]

APPS.MSC_WS_IO dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 437: FROM msd_dp_scenario_output_levels

433: l_scenario_lvl_item NUMBER;
434: BEGIN
435: BEGIN
436: SELECT level_id INTO l_scenario_lvl_geo
437: FROM msd_dp_scenario_output_levels
438: WHERE scenario_id = SchId AND level_id in (11,15,41,42,30);
439: EXCEPTION WHEN NO_DATA_FOUND THEN
440: l_scenario_lvl_geo := 30;
441: WHEN others THEN

Line 448: FROM msd_dp_scenario_output_levels

444: END;
445:
446: BEGIN
447: SELECT level_id INTO l_scenario_lvl_item
448: FROM msd_dp_scenario_output_levels
449: WHERE scenario_id = SchId AND level_id in (34,40);
450: EXCEPTION WHEN NO_DATA_FOUND THEN
451: l_scenario_lvl_item := 40;
452: WHEN others THEN