DBA Data[Home] [Help]

APPS.FPA_PROCESS_PVT dependencies on FPA_AW_SCE_INFO_V

Line 2526: from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset

2522:
2523:
2524: cursor c_init_project_set is
2525: select pset.INIT_PROJECT_SET_ID
2526: from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset
2527: where sc.planning_cycle = pc.planning_cycle
2528: and pc.portfolio = pset.portfolio
2529: and sc.scenario = p_scenario_id;
2530:

Line 2572: from fpa_aw_sce_info_v

2568:
2569: -- Now we get the Initial Scenario Id.
2570: select scenario
2571: into l_init_scenario_id
2572: from fpa_aw_sce_info_v
2573: where is_initial_scenario = 1
2574: and planning_cycle = (select planning_cycle
2575: from fpa_aw_sces_v
2576: where scenario = p_scenario_id);