[Home] [Help]
528: BEGIN
529: SELECT
530: 1 INTO l_Dummy
531: FROM
532: msd_dp_ascp_scenarios_v
533: WHERE
534: global_scenario_flag = 'Y' AND
535: scenario_name <> PlanName AND
536: scenario_id = SchId;
816: UNION
817: SELECT
818: 7, -1
819: FROM
820: msd_dp_ascp_scenarios_v
821: WHERE
822: global_scenario_flag ='N' AND
823: scenario_name <> PlanName AND
824: scenario_id = SchId AND