DBA Data[Home] [Help]

APPS.FPA_SCENARIO_PVT dependencies on FPA_AW_SCE_INFO_V

Line 1040: from fpa_aw_sce_info_v

1036: -- and then invoke this api in pjp mode to add the same project to the current sce.
1037:
1038: select scenario
1039: into source_scen_id
1040: from fpa_aw_sce_info_v
1041: where planning_cycle =
1042: (select planning_cycle from fpa_aw_sce_info_v where scenario = p_target_scen_id)
1043: and is_initial_scenario = 1 ;
1044:

Line 1042: (select planning_cycle from fpa_aw_sce_info_v where scenario = p_target_scen_id)

1038: select scenario
1039: into source_scen_id
1040: from fpa_aw_sce_info_v
1041: where planning_cycle =
1042: (select planning_cycle from fpa_aw_sce_info_v where scenario = p_target_scen_id)
1043: and is_initial_scenario = 1 ;
1044:
1045: l_str := 'call copy_proj_data_prg(' || p_target_scen_id || ', ' || source_scen_id || ', '' ' || p_project_id_str || ''')';
1046: dbms_aw.execute(l_str);