APPS.PAY_PAYACT_PKG dependencies on PER_ASSIGNMENTS_F

Line 178: per_assignments_f asg

174: distinct asg.person_id
175: from pay_payroll_actions ppa,
176: pay_payroll_actions pa1,
177: pay_assignment_actions act,
178: per_assignments_f asg
179: where ppa.payroll_action_id = :payroll_action_id
180: '||l_consolidation_set_text||'
181: '||l_payroll_text||'
182: and pa1.effective_date between ppa.start_date

Line 247: per_assignments_f paf,

243: select act.assignment_action_id,
244: act.assignment_id,
245: act.tax_unit_id
246: from pay_assignment_actions act,
247: per_assignments_f paf,
248: pay_payroll_actions ppa, /* pre-payments and reversals
249: payroll action id */
250: pay_payrolls_f ppf -- Bug 3372732
251: where ppa.payroll_id = nvl(c_payroll_id,ppa.payroll_id)

Line 303: per_assignments_f paf,

299: select act.assignment_action_id,
300: act.assignment_id,
301: act.tax_unit_id
302: from pay_assignment_actions act,
303: per_assignments_f paf,
304: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
305: pay_payrolls_f ppf -- Bug 3372732
306: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
307: and ppa.consolidation_set_id +0 =

Line 358: per_assignments_f paf,

354: select act.assignment_action_id,
355: act.assignment_id,
356: act.tax_unit_id
357: from pay_assignment_actions act,
358: per_assignments_f paf,
359: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
360: pay_payrolls_f ppf -- Bug 3372732
361: where ppa.payroll_id =
362: nvl(c_payroll_id, ppa.payroll_id)

Line 413: per_assignments_f paf,

409: select act.assignment_action_id,
410: act.assignment_id,
411: act.tax_unit_id
412: from pay_assignment_actions act,
413: per_assignments_f paf,
414: pay_payroll_actions ppa, /* pre-payments and reversals */
415: /* payroll action id */
416: pay_payrolls_f ppf -- Bug 3372732
417: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)

Line 468: per_assignments_f paf,

464: select act.assignment_action_id,
465: act.assignment_id,
466: act.tax_unit_id
467: from pay_assignment_actions act,
468: per_assignments_f paf,
469: pay_payroll_actions ppa, /* pre-payments and */
470: /* reversals payroll action id */
471: pay_payrolls_f ppf -- Bug 3372732
472: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)

Line 523: per_assignments_f paf,

519: select act.assignment_action_id,
520: act.assignment_id,
521: act.tax_unit_id
522: from pay_assignment_actions act,
523: per_assignments_f paf,
524: pay_payroll_actions ppa, /* pre-payments and */
525: /* reversals payroll action id */
526: pay_payrolls_f ppf
527: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)

Line 577: per_assignments_f paf,

573: select act.assignment_action_id,
574: act.assignment_id,
575: act.tax_unit_id
576: from pay_assignment_actions act,
577: per_assignments_f paf,
578: pay_payroll_actions ppa, /* pre-payments and */
579: /* reversals payroll action id */
580: pay_payrolls_f ppf -- Bug 3372732
581: where ppa.payroll_id =

Line 632: per_assignments_f paf,

628: select act.assignment_action_id,
629: act.assignment_id,
630: act.tax_unit_id
631: from pay_assignment_actions act,
632: per_assignments_f paf,
633: pay_payroll_actions ppa, /* pre-payments and */
634: /* reversals payroll action id */
635: pay_payrolls_f ppf
636: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)