APPS.FPA_PROJECT_PVT dependencies on PA_PROJECTS_ALL

Line 37: FROM PA_PROJECTS_ALL

33: CURSOR FUNDING_STATUS_CSR
34: (P_PROJECT_ID IN NUMBER) IS
35: SELECT
36: 'T'
37: FROM PA_PROJECTS_ALL
38: WHERE PROJECT_ID = P_PROJECT_ID
39: AND FUNDING_APPROVAL_STATUS_CODE IN
40: ('FUNDING_PROPOSED','FUNDING_ONHOLD','FUNDING_APPROVED');
41:

Line 64: PA_PROJECTS_ALL PA,

60: PTF.PORTFOLIO_ORGANIZATION,
61: PA.CARRYING_OUT_ORGANIZATION_ID
62: FROM
63: PA_PROJECT_CLASSES PAC,
64: PA_PROJECTS_ALL PA,
65: PA_CLASS_CODES PCC,
66: FPA_AW_PORTF_HEADERS_V PTF
67: WHERE
68: PTF.PORTFOLIO_CLASS_CODE = PCC.CLASS_CODE_ID

Line 420: PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B

416: DECODE(B.BUDGET_VERSION_ID,NULL,-1,B.BUDGET_VERSION_ID) BENF_BUDGET_VERSN_ID
417: INTO
418: L_NEW_COST_VERSION_ID, L_NEW_BENEFIT_VERSION_ID
419: FROM
420: PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B
421: WHERE
422: 'B' = C.BUDGET_STATUS_CODE (+) AND 'Y' = C.CURRENT_FLAG (+)
423: AND fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST') = C.FIN_PLAN_TYPE_ID (+)
424: AND 'B' = B.BUDGET_STATUS_CODE (+) AND 'Y' = B.CURRENT_FLAG (+)

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

Line 1051: UPDATE PA_PROJECTS_ALL

1047: FETCH c_approved_projects into l_approved_projects;
1048:
1049: EXIT WHEN c_approved_projects%NOTFOUND;
1050:
1051: UPDATE PA_PROJECTS_ALL
1052: SET FUNDING_APPROVAL_STATUS_CODE = l_approved_projects.recommended_funding_status
1053: WHERE ROWID = l_approved_projects.rowid;
1054: --WHERE project_id = l_approved_projects.project;
1055: