DBA Data[Home] [Help]

APPS.FPA_SCORECARDS_PVT dependencies on FPA_AW_PC_INFO_V

Line 1039: FPA_AW_PC_INFO_V PC, FPA_AW_SCES_V SCEP, FPA_AW_SCE_INFO_V SCE

1035: SELECT
1036: PC.PC_STATUS, PC.PORTFOLIO, PC.PLANNING_CYCLE,
1037: SCE.RECOMMENDED_FLAG, SCE.APPROVED_FLAG, SCE.IS_INITIAL_SCENARIO
1038: FROM
1039: FPA_AW_PC_INFO_V PC, FPA_AW_SCES_V SCEP, FPA_AW_SCE_INFO_V SCE
1040: WHERE
1041: SCEP.SCENARIO = SCE.SCENARIO
1042: AND SCEP.PLANNING_CYCLE = PC.PLANNING_CYCLE
1043: AND SCEP.SCENARIO = P_SCENARIO_ID;

Line 1049: FPA_AW_PC_INFO_V PC

1045: CURSOR PC_CSR (P_PC_ID IN NUMBER) IS
1046: SELECT
1047: PC.PC_STATUS, PC.PORTFOLIO, PC.SCENARIO_COUNT
1048: FROM
1049: FPA_AW_PC_INFO_V PC
1050: WHERE
1051: PC.PLANNING_CYCLE = P_PC_ID;
1052:
1053: l_priv_develop_scen VARCHAR2(1) := null;

Line 1057: l_pc_status FPA_AW_PC_INFO_V.PC_STATUS%TYPE;

1053: l_priv_develop_scen VARCHAR2(1) := null;
1054: l_portfolio_id NUMBER;
1055: l_pc_id NUMBER;
1056: l_scen_count NUMBER;
1057: l_pc_status FPA_AW_PC_INFO_V.PC_STATUS%TYPE;
1058: l_scen_rec_flag FPA_AW_SCE_INFO_V.RECOMMENDED_FLAG%TYPE;
1059: l_scen_app_flag FPA_AW_SCE_INFO_V.APPROVED_FLAG%TYPE;
1060: l_scen_ini_flag FPA_AW_SCE_INFO_V.IS_INITIAL_SCENARIO%TYPE;
1061: