eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRASSACT dependencies on PER_BUSINESS_GROUPS_PERF

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

204: adjustments.
205: 13-NOV-2003 nbristow 115.85 Reversal was not correctly
206: setting the jurisdiction code
207: in sparse mode.
208: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
209: per_all_people_f and
210: pay_all_payrolls_f. Performance
211: fix to seqper cursors.
212: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and

Line 1161: per_business_groups_perf grp,

1157: p_pact_rec.payroll_name,
1158: p_pact_rec.bg_name
1159: from pay_payroll_actions pac,
1160: pay_all_payrolls_f pay,
1161: per_business_groups_perf grp,
1162: hr_lookups hrl
1163: where pac.payroll_action_id = p_pact_rec.pact_id
1164: and hrl.lookup_code = pac.action_type
1165: and hrl.lookup_type = 'ACTION_TYPE'

Line 4335: per_business_groups_perf pbg,

4331: pbg.legislation_code,
4332: asg.person_id
4333: into effdate, actype, lgcode, persid
4334: from
4335: per_business_groups_perf pbg,
4336: per_all_assignments_f asg,
4337: pay_payroll_actions pac
4338: where pac.payroll_action_id = pactid
4339: and pbg.business_group_id = asg.business_group_id

Line 4666: from per_business_groups_perf grp,

4662: --
4663: -- get the rule_mode
4664: select /*+ ORDERED*/ plr.rule_mode
4665: into rmode
4666: from per_business_groups_perf grp,
4667: pay_legislation_rules plr
4668: where grp.business_group_id = bgid
4669: and plr.legislation_code = grp.legislation_code
4670: and plr.rule_type = 'I'

Line 4715: per_business_groups_perf pbg,

4711: 1,
4712: hr_dynsql.get_tax_unit(asg.assignment_id,
4713: pac.effective_date)
4714: from
4715: per_business_groups_perf pbg,
4716: per_all_assignments_f asg,
4717: per_all_assignments_f as2,
4718: pay_payroll_actions pac
4719: where pac.payroll_action_id = pactid

Line 4759: per_business_groups_perf pbg,

4755: 1,
4756: hr_dynsql.get_tax_unit(asg.assignment_id,
4757: pac.effective_date)
4758: from
4759: per_business_groups_perf pbg,
4760: per_all_assignments_f asg,
4761: per_all_assignments_f as2,
4762: pay_payroll_actions pac
4763: where pac.payroll_action_id = pactid

Line 4810: from per_business_groups_perf pbg,

4806: aa_id,
4807: 1,
4808: hr_dynsql.get_tax_unit(asg.assignment_id,
4809: pac.effective_date)
4810: from per_business_groups_perf pbg,
4811: per_all_assignments_f asg,
4812: per_all_assignments_f as2,
4813: pay_object_groups pog,
4814: pay_payroll_actions pac

Line 4861: from per_business_groups_perf pbg,

4857: aa_id,
4858: 1,
4859: hr_dynsql.get_tax_unit(asg.assignment_id,
4860: pac.effective_date)
4861: from per_business_groups_perf pbg,
4862: per_all_assignments_f asg,
4863: per_all_assignments_f as2,
4864: pay_object_groups pog,
4865: pay_payroll_actions pac

Line 4921: from per_business_groups_perf pbg,

4917: aa_id,
4918: 1,
4919: hr_dynsql.get_tax_unit(asg.assignment_id,
4920: pac.effective_date)
4921: from per_business_groups_perf pbg,
4922: per_all_assignments_f asg,
4923: per_all_assignments_f as2,
4924: per_periods_of_service pos,
4925: pay_payroll_actions pac

Line 4971: from per_business_groups_perf pbg,

4967: aa_id,
4968: 1,
4969: hr_dynsql.get_tax_unit(asg.assignment_id,
4970: pac.effective_date)
4971: from per_business_groups_perf pbg,
4972: per_all_assignments_f asg,
4973: per_all_assignments_f as2,
4974: per_periods_of_service pos,
4975: pay_payroll_actions pac

Line 5101: from per_business_groups_perf pbg,

5097: aa_id,
5098: 1,
5099: hr_dynsql.get_tax_unit(asg.assignment_id,
5100: pac.effective_date)
5101: from per_business_groups_perf pbg,
5102: pay_assignment_actions act,
5103: pay_payroll_actions pac, -- prepay action.
5104: pay_payroll_actions pa2, -- the QuickPay action.
5105: per_periods_of_service pos,

Line 5382: leg_code per_business_groups_perf.legislation_code%type;

5378: cxt_id number;
5379:
5380: found number;
5381: rev_assact number; -- reversal assignment_action_id.
5382: leg_code per_business_groups_perf.legislation_code%type;
5383: l_process_path pay_assignment_actions.process_path%type;
5384: l_found boolean;
5385: l_inp_val_name pay_input_values_f.name%type;
5386: l_rev_lat_bal_maintenance boolean;

Line 5424: per_business_groups_perf pbg,

5420: into asgid, taxunt,run_type_id, leg_code
5421: from pay_action_classifications acl,
5422: pay_assignment_actions ac2,
5423: pay_payroll_actions pa2,
5424: per_business_groups_perf pbg,
5425: pay_payroll_actions pac
5426: where pac.payroll_action_id = pactid
5427: and pbg.business_group_id = pac.business_group_id
5428: and ac2.assignment_action_id = assactid

Line 6737: per_business_groups_perf pbg

6733: l_original_entry_id
6734: from pay_element_entries_f pee,
6735: per_all_assignments_f asg,
6736: per_time_periods ptp,
6737: per_business_groups_perf pbg
6738: where pee.element_entry_id = eentryid
6739: and effdate between
6740: pee.effective_start_date and pee.effective_end_date
6741: and asg.assignment_id = pee.assignment_id

Line 8739: from per_business_groups_perf grp,

8735: -- get the rule_mode
8736: begin
8737: select /*+ ORDERED*/ plr.rule_mode
8738: into v_r_mode
8739: from per_business_groups_perf grp,
8740: pay_legislation_rules plr
8741: where grp.business_group_id = v_business_group_id
8742: and plr.legislation_code = grp.legislation_code
8743: and plr.rule_type = 'I'