DBA Data[Home] [Help]

APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT dependencies on FPA_AW_PROJ_INFO_V

Line 457: FROM fpa_aw_proj_info_v

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

Line 468: FROM fpa_aw_proj_info_v

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;