583: END IF;
584:
585: -- Count scenarios in Recommended status.
586: select count(scenario) into l_scenario_count
587: from fpa_aw_sce_info_v
588: where planning_cycle = p_planning_cycle_id
589: and recommended_flag = 1;
590:
591: IF l_scenario_count > 0 then
639: END IF;
640:
641: -- Count scenarios in approved status.
642: select count(scenario) into l_scenario_count
643: from fpa_aw_sce_info_v
644: where planning_cycle = p_planning_cycle_id
645: and approved_flag = 1;
646:
647: IF l_scenario_count > 0 then