APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_PLAN_DESIGN_PROGRAM_MODULE

Line 1998: -- Bug : 3752407 : Global cursor ben_plan_design_program_module.g_table_route will now be used

1994: procedure build_abr_hierarchy
1995: ( p_copy_entity_txn_id in number )
1996: is
1997: --
1998: -- Bug : 3752407 : Global cursor ben_plan_design_program_module.g_table_route will now be used
1999: --
2000: -- cursor c_table_route is
2001: -- select table_route_id
2002: -- from pqh_table_route

Line 2036: open ben_plan_design_program_module.g_table_route('ABR') ;

2032: l_counter number := 1 ;
2033: --
2034: begin
2035: --
2036: open ben_plan_design_program_module.g_table_route('ABR') ;
2037: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2038: close ben_plan_design_program_module.g_table_route ;
2039: --
2040: for i in c_hierarchy(p_copy_entity_txn_id,l_table_route_id) loop

Line 2037: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2033: --
2034: begin
2035: --
2036: open ben_plan_design_program_module.g_table_route('ABR') ;
2037: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2038: close ben_plan_design_program_module.g_table_route ;
2039: --
2040: for i in c_hierarchy(p_copy_entity_txn_id,l_table_route_id) loop
2041: --

Line 2038: close ben_plan_design_program_module.g_table_route ;

2034: begin
2035: --
2036: open ben_plan_design_program_module.g_table_route('ABR') ;
2037: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2038: close ben_plan_design_program_module.g_table_route ;
2039: --
2040: for i in c_hierarchy(p_copy_entity_txn_id,l_table_route_id) loop
2041: --
2042: update ben_copy_entity_results cpe