DBA Data[Home] [Help]

APPS.MSC_WS_ASCP dependencies on MSD_DP_SCN_OUTPUT_LEVELS_V

Line 571: FROM msd_dp_scn_output_levels_v

567: l_scenario_lvl_item NUMBER;
568: BEGIN
569: BEGIN
570: SELECT level_id INTO l_scenario_lvl_geo
571: FROM msd_dp_scn_output_levels_v
572: WHERE
573: scenario_id = SchId AND
574: level_id IN (11,15,41,42,30);
575: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 584: FROM msd_dp_scn_output_levels_v

580: END;
581:
582: BEGIN
583: SELECT level_id INTO l_scenario_lvl_item
584: FROM msd_dp_scn_output_levels_v
585: WHERE
586: scenario_id = SchId AND
587: level_id IN (34, 40);
588: EXCEPTION WHEN NO_DATA_FOUND THEN