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_AU_REC_DET_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 340: per_assignments_f paaf,

336: paa.action_sequence,
337: paaf.assignment_id,
338: paa.tax_unit_id
339: from per_people_f pap,
340: per_assignments_f paaf,
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,

Line 365: From per_assignments_f iipaf

361: and hou.organization_id = c_organization_id
362: and ppa1.effective_date between c_archive_start_date and c_archive_end_date
363: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_archive_end_date)),1,'Y','N')) LIKE c_employee_type --4161540
364: and paaf.effective_end_date = (select max(effective_end_date) --Bug# 3538810
365: From per_assignments_f iipaf
366: WHERE iipaf.assignment_id = paaf.assignment_id
367: and iipaf.effective_end_date >= c_archive_start_date
368: and iipaf.effective_start_date <= c_archive_end_date)
369: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id;

Line 393: per_assignments_f paaf,

389: paa.action_sequence,
390: paaf.assignment_id,
391: paa.tax_unit_id
392: from per_people_f pap,
393: per_assignments_f paaf,
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,
397: hr_organization_units hou,

Line 440: per_assignments_f paaf,

436: paa.action_sequence,
437: paaf.assignment_id,
438: paa.tax_unit_id
439: from per_people_f pap,
440: per_assignments_f paaf,
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,
444: per_periods_of_service pps

Line 462: From per_assignments_f iipaf

458: and paa.tax_unit_id = c_legal_employer
459: and ppa1.effective_date between c_archive_start_date and c_archive_end_date
460: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_archive_end_date)),1,'Y','N')) LIKE c_employee_type --bug 4161540
461: and paaf.effective_end_date = (select max(effective_end_date) --Bug# 3538810
462: From per_assignments_f iipaf
463: WHERE iipaf.assignment_id = paaf.assignment_id
464: and iipaf.effective_end_date >= c_archive_start_date
465: and iipaf.effective_start_date <= c_archive_end_date)
466: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id;

Line 491: per_assignments_f paaf,

487: paa.action_sequence,
488: paaf.assignment_id,
489: paa.tax_unit_id
490: from per_people_f pap,
491: per_assignments_f paaf,
492: pay_payroll_actions ppa,
493: pay_payroll_actions ppa1,
494: pay_assignment_actions paa,
495: per_periods_of_service pps

Line 535: per_assignments_f paaf,

531: paa.action_sequence,
532: paaf.assignment_id,
533: paa.tax_unit_id
534: from per_people_f pap,
535: per_assignments_f paaf,
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,
539: per_periods_of_service pps

Line 557: From per_assignments_f iipaf

553: and ppa1.effective_date between c_archive_start_date and c_archive_end_date
554: AND paaf.payroll_id = c_payroll_id /*Bug 4040688*/
555: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_archive_end_date)),1,'Y','N')) LIKE c_employee_type --Bug 4161540
556: and paaf.effective_end_date = (select max(effective_end_date) --Bug# 3538810
557: From per_assignments_f iipaf
558: WHERE iipaf.assignment_id = paaf.assignment_id
559: and iipaf.effective_end_date >= c_archive_start_date
560: and iipaf.effective_start_date <= c_archive_end_date
561: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688872*/

Line 585: per_assignments_f paaf,

581: paa.action_sequence,
582: paaf.assignment_id,
583: paa.tax_unit_id
584: from per_people_f pap,
585: per_assignments_f paaf,
586: pay_payroll_actions ppa,
587: pay_payroll_actions ppa1,
588: pay_assignment_actions paa,
589: per_periods_of_service pps

Line 630: per_assignments_f paaf,

626: paa.action_sequence,
627: paaf.assignment_id,
628: paa.tax_unit_id
629: from per_people_f pap,
630: per_assignments_f paaf,
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,
634: per_periods_of_service pps

Line 652: From per_assignments_f iipaf

648: and paa.assignment_id = c_assignment_id
649: and ppa1.effective_date between c_archive_start_date and c_archive_end_date
650: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_archive_end_date)),1,'Y','N')) LIKE c_employee_type --Bug 4161540
651: and paaf.effective_end_date = (select max(effective_end_date) --Bug# 3538810
652: From per_assignments_f iipaf
653: WHERE iipaf.assignment_id = paaf.assignment_id
654: and iipaf.effective_end_date >= c_archive_start_date
655: and iipaf.effective_start_date <= c_archive_end_date)
656: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id;

Line 679: per_assignments_f paaf,

675: paa.action_sequence,
676: paaf.assignment_id,
677: paa.tax_unit_id
678: from per_people_f pap,
679: per_assignments_f paaf,
680: pay_payroll_actions ppa,
681: pay_payroll_actions ppa1,
682: pay_assignment_actions paa,
683: per_periods_of_service pps

Line 722: per_assignments_f paaf,

718: paa.action_sequence,
719: paaf.assignment_id,
720: paa.tax_unit_id
721: from per_people_f pap,
722: per_assignments_f paaf,
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,
726: per_periods_of_service pps

Line 743: From per_assignments_f iipaf

739: and ppa1.action_type in ('R','Q','I','B','V')
740: and ppa1.effective_date between c_archive_start_date and c_archive_end_date
741: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_archive_end_date)),1,'Y','N')) LIKE c_employee_type --Bug 4161540
742: and paaf.effective_end_date = (select max(effective_end_date) --Bug# 3538810
743: From per_assignments_f iipaf
744: WHERE iipaf.assignment_id = paaf.assignment_id
745: and iipaf.effective_end_date >= c_archive_start_date
746: and iipaf.effective_start_date <= c_archive_end_date)
747: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id;

Line 769: per_assignments_f paaf,

765: paa.action_sequence,
766: paaf.assignment_id,
767: paa.tax_unit_id
768: from per_people_f pap,
769: per_assignments_f paaf,
770: pay_payroll_actions ppa,
771: pay_payroll_actions ppa1,
772: pay_assignment_actions paa,
773: per_periods_of_service pps

Line 1568: per_assignments_f paa,

1564: -- papf.payroll_name, /*Bug 4132525, Bug 4688872*/
1565: hsc.segment1 tax_unit_id, /*Bug 4040688*/
1566: hou1.NAME Legal_Employer /*Bug 4132525*/
1567: from per_people_f pap,
1568: per_assignments_f paa,
1569: per_grades_tl pgr, /* Bug 3953702*/
1570: per_periods_of_service pps,
1571: per_pay_bases ppb,
1572: per_pay_proposals pro,

Line 1593: from per_assignments_f

1589: and pps.period_of_service_id = paa.period_of_service_id
1590: AND paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id /*Bug 4040688*/
1591: and paa.assignment_status_type_id = past.assignment_status_type_id
1592: and paa.effective_end_date = ( select max(effective_end_date) /*Bug#3662449 sub query added*/
1593: from per_assignments_f
1594: WHERE assignment_id = c_assignment_id
1595: and effective_end_date >= c_start_date
1596: and effective_start_date <= c_end_date)
1597: and c_end_date between pap.effective_start_date and pap.effective_end_date

Line 1619: From per_assignments_f iipaf

1615: FROM per_all_assignments_f paaf,
1616: pay_payrolls_f pay
1617: WHERE paaf.assignment_id = c_assignment_id
1618: and paaf.effective_end_date = (select max(effective_end_date)
1619: From per_assignments_f iipaf
1620: WHERE iipaf.assignment_id = c_assignment_id
1621: and iipaf.effective_end_date >= c_start_date
1622: and iipaf.effective_start_date <= c_end_date
1623: AND iipaf.payroll_id IS NOT NULL)

Line 1682: ,per_assignments_f paaf

1678: ,pay_element_classifications pec
1679: ,pay_assignment_actions paa
1680: ,pay_assignment_actions paa2 /*Bug 3935471*/
1681: ,pay_payroll_actions ppa
1682: ,per_assignments_f paaf
1683: ,pay_run_results prr
1684: ,pay_run_result_values prrv
1685: ,pay_element_classifications pec2
1686: ,pay_sub_classification_rules_f pscr

Line 1732: , per_assignments_f paf

1728: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1729: ,max(paa.action_sequence)
1730: from pay_assignment_actions paa
1731: , pay_payroll_actions ppa
1732: , per_assignments_f paf
1733: where paa.assignment_id = paf.assignment_id
1734: and paf.assignment_id = c_assignment_id
1735: and ppa.payroll_action_id = paa.payroll_action_id
1736: and ppa.effective_date between c_start_date and c_end_date

Line 1752: , per_assignments_f paf

1748: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1749: ,max(paa.action_sequence)
1750: from pay_assignment_actions paa
1751: , pay_payroll_actions ppa
1752: , per_assignments_f paf
1753: where paa.assignment_id = paf.assignment_id
1754: and paf.assignment_id = c_assignment_id
1755: and ppa.payroll_action_id = paa.payroll_action_id
1756: and ppa.payroll_action_id = c_payroll_action_id