DBA Data[Home] [Help]

APPS.HRASSACT dependencies on HR_DYNSQL

Line 4347: taxunt2 := hr_dynsql.get_tax_unit(asgid, effdate);

4343: --
4344: if (actyp not in ('V','B','I'))
4345: or ((actyp in ('B','I')) and (taxunt is null)) then
4346: --
4347: taxunt2 := hr_dynsql.get_tax_unit(asgid, effdate);
4348: end if;
4349: --
4350: if g_debug then
4351: hr_utility.set_location('hrassact.irbaact',11);

Line 4712: hr_dynsql.get_tax_unit(asg.assignment_id,

4708: 'U',
4709: 1,
4710: aa_id,
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,

Line 4756: hr_dynsql.get_tax_unit(asg.assignment_id,

4752: 'U',
4753: 1,
4754: aa_id,
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,

Line 4808: hr_dynsql.get_tax_unit(asg.assignment_id,

4804: 'U',
4805: 1,
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,

Line 4859: hr_dynsql.get_tax_unit(asg.assignment_id,

4855: 'U',
4856: 1,
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,

Line 4919: hr_dynsql.get_tax_unit(asg.assignment_id,

4915: 'U',
4916: 1,
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,

Line 4969: hr_dynsql.get_tax_unit(asg.assignment_id,

4965: 'U',
4966: 1,
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,

Line 5099: hr_dynsql.get_tax_unit(asg.assignment_id,

5095: 'U',
5096: 1,
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.