APPS.PAY_RETRO_PKG dependencies on PER_BUSINESS_GROUPS

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

Line 1592: legcode per_business_groups.legislation_code%type;

1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;
1592: legcode per_business_groups.legislation_code%type;
1593: l_jc_name varchar2(40);
1594: l_rule_mode varchar2(40);
1595: l_status varchar2(40);
1596: l_rr_sparse_jc boolean;

Line 1626: per_business_groups pbg

1622: l_time_period_id,
1623: legcode
1624: from pay_payroll_actions ppa,
1625: pay_assignment_actions paa,
1626: per_business_groups pbg
1627: where ppa.payroll_action_id = paa.payroll_action_id
1628: and pbg.business_group_id = ppa.business_group_id
1629: and paa.assignment_action_id = p_asg_act_id;
1630: --