DBA Data[Home] [Help]

APPS.FPA_PROJECT_PVT dependencies on FPA_AW_PROJ_INFO_V

Line 331: from fpa_aw_proj_info_v

327: new_projs PROJTABLE;
328:
329: cursor all_projs is
330: select project
331: from fpa_aw_proj_info_v
332: where scenario = p_scenario_id;
333:
334: cursor one_proj is
335: select p_project_id

Line 1017: from pa_projects_all ppa, fpa_aw_proj_info_v sceproj

1013: x_msg_data OUT NOCOPY VARCHAR2) IS
1014:
1015: cursor c_approved_projects IS
1016: select ppa.rowid, project_id, recommended_funding_status
1017: from pa_projects_all ppa, fpa_aw_proj_info_v sceproj
1018: where scenario = p_appr_scenario_id and sceproj.project = ppa.project_id;
1019: ----------------------------------------------------
1020: -- Bug Reference :6622099, The For Update clause
1021: -- is used if its referenced inside Current of clause