APPS.PAY_RETRO_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 110: g_bus_grp per_business_groups_perf.business_group_id%type := null;

106: jalloun 30-JUL-1996 Added error handling.
107: nbristow 12-MAR-1996 Created
108: */
109: -- Caches for get_reprocess_type
110: g_bus_grp per_business_groups_perf.business_group_id%type := null;
111: g_leg_code per_business_groups_perf.legislation_code%type := null;
112: --
113: procedure retro_run_proc
114: is

Line 111: g_leg_code per_business_groups_perf.legislation_code%type := null;

107: nbristow 12-MAR-1996 Created
108: */
109: -- Caches for get_reprocess_type
110: g_bus_grp per_business_groups_perf.business_group_id%type := null;
111: g_leg_code per_business_groups_perf.legislation_code%type := null;
112: --
113: procedure retro_run_proc
114: is
115: begin

Line 481: l_leg_code per_business_groups_perf.legislation_code%type;

477: --
478: else
479: --
480: declare
481: l_leg_code per_business_groups_perf.legislation_code%type;
482: begin
483: --
484: select legislation_code
485: into l_leg_code

Line 486: from per_business_groups_perf

482: begin
483: --
484: select legislation_code
485: into l_leg_code
486: from per_business_groups_perf
487: where business_group_id = p_business_group_id;
488: --
489: select pesu.retro_element_type_id
490: into l_retro_ele_type_id