APPS.FPA_SCORECARDS_PVT dependencies on FPA_AW_PC_INFO_V

Line 1038: FPA_AW_PC_INFO_V PC, FPA_AW_SCES_V SCEP, FPA_AW_SCE_INFO_V SCE

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

Line 1048: FPA_AW_PC_INFO_V PC

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

Line 1056: l_pc_status FPA_AW_PC_INFO_V.PC_STATUS%TYPE;

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