453: IF l_scenario_project_set_rec.approved_flag = 1 then
454: BEGIN
455: SELECT project BULK COLLECT
456: INTO l_proj_list
457: FROM fpa_aw_proj_info_v
458: WHERE scenario = p_scen_id and
459: recommended_funding_status = 'FUNDING_APPROVED';
460: EXCEPTION
461: WHEN OTHERS THEN
464: ELSIF l_scenario_project_set_rec.is_initial_scenario = 1 then
465: BEGIN
466: SELECT project BULK COLLECT
467: INTO l_proj_list
468: FROM fpa_aw_proj_info_v
469: WHERE scenario = p_scen_id;
470: EXCEPTION
471: WHEN OTHERS THEN
472: null;