APPS.FPA_SCORECARDS_PVT dependencies on FPA_AW_SCE_INFO_V

Line 576: FPA_AW_SCE_INFO_V SCEI, FPA_AW_SCE_INFO_V SCE, FPA_AW_SCES_V PC

572: CURSOR INIT_SCENARIO_CSR (P_SCENARIO_ID IN NUMBER) IS
573: SELECT
574: PC.PLANNING_CYCLE, SCEI.SCENARIO
575: FROM
576: FPA_AW_SCE_INFO_V SCEI, FPA_AW_SCE_INFO_V SCE, FPA_AW_SCES_V PC
577: WHERE
578: SCEI.IS_INITIAL_SCENARIO = 1
579: AND SCE.PLANNING_CYCLE = PC.PLANNING_CYCLE
580: AND SCEI.PLANNING_CYCLE = PC.PLANNING_CYCLE

Line 819: fpa_aw_sce_info_v scei, fpa_aw_sce_info_v sce, fpa_aw_sces_v pc

815: CURSOR initial_scenario_csr (p_scenario_id in number) IS
816: select
817: scei.scenario
818: from
819: fpa_aw_sce_info_v scei, fpa_aw_sce_info_v sce, fpa_aw_sces_v pc
820: where
821: scei.is_initial_scenario = 1
822: and sce.planning_cycle = pc.planning_cycle
823: and scei.planning_cycle = pc.planning_cycle

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 1058: l_scen_rec_flag FPA_AW_SCE_INFO_V.RECOMMENDED_FLAG%TYPE;

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:
1062: BEGIN

Line 1059: l_scen_app_flag FPA_AW_SCE_INFO_V.APPROVED_FLAG%TYPE;

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:
1062: BEGIN
1063:

Line 1060: l_scen_ini_flag FPA_AW_SCE_INFO_V.IS_INITIAL_SCENARIO%TYPE;

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:
1062: BEGIN
1063:
1064: l_pc_id := p_planning_cycle_id;