APPS.FPA_SCORECARDS_PVT dependencies on FPA_AW_SCES_V

Line 575: FPA_AW_SCE_INFO_V SCEI, FPA_AW_SCE_INFO_V SCE, FPA_AW_SCES_V PC

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

Line 818: fpa_aw_sce_info_v scei, fpa_aw_sce_info_v sce, fpa_aw_sces_v pc

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

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;