APPS.PAY_RETRO_PKG dependencies on PER_BUSINESS_GROUPS_PERF

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

122: jalloun 30-JUL-1996 Added error handling.
123: nbristow 12-MAR-1996 Created
124: */
125: -- Caches for get_reprocess_type
126: g_bus_grp per_business_groups_perf.business_group_id%type := null;
127: g_leg_code per_business_groups_perf.legislation_code%type := null;
128: --
129: procedure retro_run_proc
130: is

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

123: nbristow 12-MAR-1996 Created
124: */
125: -- Caches for get_reprocess_type
126: g_bus_grp per_business_groups_perf.business_group_id%type := null;
127: g_leg_code per_business_groups_perf.legislation_code%type := null;
128: --
129: procedure retro_run_proc
130: is
131: begin

Line 499: l_leg_code per_business_groups_perf.legislation_code%type;

495: --
496: else
497: --
498: declare
499: l_leg_code per_business_groups_perf.legislation_code%type;
500: begin
501: --
502: hr_utility.trace('p_payroll_id:'||p_payroll_id);
503: hr_utility.trace('p_assact_id:'||p_assact_id);

Line 506: from per_business_groups_perf

502: hr_utility.trace('p_payroll_id:'||p_payroll_id);
503: hr_utility.trace('p_assact_id:'||p_assact_id);
504: select legislation_code
505: into l_leg_code
506: from per_business_groups_perf
507: where business_group_id = p_business_group_id;
508: --
509: select pesu.retro_element_type_id
510: into l_retro_ele_type_id