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_ZA_IRP5_ARCHIVE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 89: cursor get_asg(p_payroll_id pay_all_payrolls_f.payroll_id%TYPE) is

85: */
86: --Modified cursor get_asg to date effectively select assignments as at Tax Year End
87: --and to limit them to where the payroll is equal to the specific payroll that was
88: --given in the TYE Archiver SRS
89: cursor get_asg(p_payroll_id pay_all_payrolls_f.payroll_id%TYPE) is
90: SELECT /*+ INDEX(asg PER_ASSIGNMENTS_F_N12) */
91: /* we used the above hint to always ensure that the use the person_id
92: index on per_assignments_f, otherwise, it is feasible the CBO may decide to
93: choose the N7 (payroll_id) index due to it being a bind */

Line 98: , pay_all_payrolls_f ppf

94: asg.person_id person_id
95: , asg.assignment_id assignment_id
96: FROM
97: per_all_assignments_f asg
98: , pay_all_payrolls_f ppf
99: , pay_payroll_actions ppa_arch
100: WHERE
101: asg.business_group_id + 0 = ppa_arch.business_group_id
102: AND asg.person_id BETWEEN stperson