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.PAY_PAYACT_PKG dependencies on PER_ASSIGNMENTS_F

Line 175: per_assignments_f asg

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

Line 244: per_assignments_f paf,

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

Line 300: per_assignments_f paf,

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

Line 355: per_assignments_f paf,

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

Line 410: per_assignments_f paf,

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

Line 465: per_assignments_f paf,

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

Line 520: per_assignments_f paf,

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

Line 574: per_assignments_f paf,

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

Line 629: per_assignments_f paf,

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