APPS.HRASSACT dependencies on PER_BUSINESS_GROUPS_PERF

Line 176: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,

172: adjustments.
173: 13-NOV-2003 nbristow 115.85 Reversal was not correctly
174: setting the jurisdiction code
175: in sparse mode.
176: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
177: per_all_people_f and
178: pay_all_payrolls_f. Performance
179: fix to seqper cursors.
180: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and

Line 1129: per_business_groups_perf grp,

1125: p_pact_rec.payroll_name,
1126: p_pact_rec.bg_name
1127: from pay_payroll_actions pac,
1128: pay_all_payrolls_f pay,
1129: per_business_groups_perf grp,
1130: hr_lookups hrl
1131: where pac.payroll_action_id = p_pact_rec.pact_id
1132: and hrl.lookup_code = pac.action_type
1133: and hrl.lookup_type = 'ACTION_TYPE'

Line 4315: per_business_groups_perf pbg,

4311: pbg.legislation_code,
4312: asg.person_id
4313: into effdate, actype, lgcode, persid
4314: from
4315: per_business_groups_perf pbg,
4316: per_all_assignments_f asg,
4317: pay_payroll_actions pac
4318: where pac.payroll_action_id = pactid
4319: and pbg.business_group_id = asg.business_group_id

Line 4646: from per_business_groups_perf grp,

4642: --
4643: -- get the rule_mode
4644: select /*+ ORDERED*/ plr.rule_mode
4645: into rmode
4646: from per_business_groups_perf grp,
4647: pay_legislation_rules plr
4648: where grp.business_group_id = bgid
4649: and plr.legislation_code = grp.legislation_code
4650: and plr.rule_type = 'I'

Line 4693: per_business_groups_perf pbg,

4689: 1,
4690: hr_dynsql.get_tax_unit(asg.assignment_id,
4691: pac.effective_date)
4692: from
4693: per_business_groups_perf pbg,
4694: per_all_assignments_f asg,
4695: per_all_assignments_f as2,
4696: pay_payroll_actions pac
4697: where pac.payroll_action_id = pactid

Line 4741: from per_business_groups_perf pbg,

4737: aa_id,
4738: 1,
4739: hr_dynsql.get_tax_unit(asg.assignment_id,
4740: pac.effective_date)
4741: from per_business_groups_perf pbg,
4742: per_all_assignments_f asg,
4743: per_all_assignments_f as2,
4744: per_periods_of_service pos,
4745: pay_payroll_actions pac

Line 4869: from per_business_groups_perf pbg,

4865: aa_id,
4866: 1,
4867: hr_dynsql.get_tax_unit(asg.assignment_id,
4868: pac.effective_date)
4869: from per_business_groups_perf pbg,
4870: pay_assignment_actions act,
4871: pay_payroll_actions pac, -- prepay action.
4872: pay_payroll_actions pa2, -- the QuickPay action.
4873: per_periods_of_service pos,

Line 5150: leg_code per_business_groups_perf.legislation_code%type;

5146: cxt_id number;
5147:
5148: found number;
5149: rev_assact number; -- reversal assignment_action_id.
5150: leg_code per_business_groups_perf.legislation_code%type;
5151: l_process_path pay_assignment_actions.process_path%type;
5152: l_found boolean;
5153: l_inp_val_name pay_input_values_f.name%type;
5154: l_rev_lat_bal_maintenance boolean;

Line 5192: per_business_groups_perf pbg,

5188: into asgid, taxunt,run_type_id, leg_code
5189: from pay_action_classifications acl,
5190: pay_assignment_actions ac2,
5191: pay_payroll_actions pa2,
5192: per_business_groups_perf pbg,
5193: pay_payroll_actions pac
5194: where pac.payroll_action_id = pactid
5195: and pbg.business_group_id = pac.business_group_id
5196: and ac2.assignment_action_id = assactid

Line 6473: per_business_groups_perf pbg

6469: l_original_entry_id
6470: from pay_element_entries_f pee,
6471: per_all_assignments_f asg,
6472: per_time_periods ptp,
6473: per_business_groups_perf pbg
6474: where pee.element_entry_id = eentryid
6475: and effdate between
6476: pee.effective_start_date and pee.effective_end_date
6477: and asg.assignment_id = pee.assignment_id

Line 8173: per_business_groups_perf pbg

8169: begin
8170: select rule_mode
8171: into l_rule_mode
8172: from pay_legislation_rules plr,
8173: per_business_groups_perf pbg
8174: where pbg.business_group_id = bus_grp_id
8175: and plr.legislation_code = pbg.legislation_code
8176: and rule_type = 'BAL_ADJ_LAT_BAL';
8177: