APPS.FPA_VALIDATION_PROCESS_PVT dependencies on PA_BUDGET_VERSIONS

Line 46: FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS V,

42: P_PLAN_TYPE IN NUMBER,
43: P_START_DATE IN DATE,
44: P_END_DATE IN DATE) IS
45: SELECT 'T'
46: FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS V,
47: PA_BUDGET_LINES L
48: WHERE
49: V.BUDGET_VERSION_ID = L.BUDGET_VERSION_ID
50: AND V.BUDGET_STATUS_CODE = 'B'

Line 485: PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B,

481: S.PROJECT PROJECT,
482: DECODE(C.BUDGET_VERSION_ID,NULL,-1,C.BUDGET_VERSION_ID) COST_BUDGET_VERSN_ID,
483: DECODE(B.BUDGET_VERSION_ID,NULL,-1,B.BUDGET_VERSION_ID) BENF_BUDGET_VERSN_ID
484: FROM
485: PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B,
486: FPA_AW_PROJ_INFO_V S
487: WHERE
488: 'B' = C.BUDGET_STATUS_CODE (+) AND 'Y' = C.CURRENT_FLAG (+)
489: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_COST') = C.FIN_PLAN_TYPE_ID (+)

Line 734: || 'FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B '

730:
731: l_sql_str := 'SELECT '
732: || 'DECODE(C.BUDGET_VERSION_ID,NULL,-1,C.BUDGET_VERSION_ID) COST_BUDGET_VERSN_ID, '
733: || 'DECODE(B.BUDGET_VERSION_ID,NULL,-1,B.BUDGET_VERSION_ID) BENF_BUDGET_VERSN_ID '
734: || 'FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B '
735: || 'WHERE ''B'' = C.BUDGET_STATUS_CODE (+) AND ''Y'' = C.CURRENT_FLAG (+) '
736: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_COST'') = C.FIN_PLAN_TYPE_ID (+) '
737: || 'AND ''B'' = B.BUDGET_STATUS_CODE (+) AND ''Y'' = B.CURRENT_FLAG (+) '
738: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_BENEFIT'') = B.FIN_PLAN_TYPE_ID (+) '

Line 1017: FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS V,

1013:
1014: CURSOR FIN_PLANS_CSR (P_PROJECT_ID IN NUMBER,
1015: P_PLAN_TYPE IN NUMBER) IS
1016: SELECT 'T'
1017: FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS V,
1018: PA_BUDGET_LINES L
1019: WHERE
1020: V.BUDGET_VERSION_ID = L.BUDGET_VERSION_ID
1021: AND V.BUDGET_STATUS_CODE = 'B'