DBA Data[Home] [Help]

APPS.FPA_VALIDATION_PROCESS_PVT dependencies on FPA_AW_PROJ_INFO_V

Line 486: FPA_AW_PROJ_INFO_V S

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 (+)
490: AND S.PROJECT = C.PROJECT_ID (+)