APPS.PAY_RETRO_PKG dependencies on PER_BUSINESS_GROUPS

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

Line 1625: legcode per_business_groups.legislation_code%type;

1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;
1625: legcode per_business_groups.legislation_code%type;
1626: l_jc_name varchar2(40);
1627: l_rule_mode varchar2(40);
1628: l_status varchar2(40);
1629: l_rr_sparse_jc boolean;

Line 1659: per_business_groups pbg

1655: l_time_period_id,
1656: legcode
1657: from pay_payroll_actions ppa,
1658: pay_assignment_actions paa,
1659: per_business_groups pbg
1660: where ppa.payroll_action_id = paa.payroll_action_id
1661: and pbg.business_group_id = ppa.business_group_id
1662: and paa.assignment_action_id = p_asg_act_id;
1663: --