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

Line 156: pay_all_payrolls_f papf,

152:
153: CURSOR cur_max_end_date IS
154: SELECT max(paaf.effective_end_date)
155: FROM per_all_assignments_f paaf,
156: pay_all_payrolls_f papf,
157: hr_soft_coding_keyflex scl
158: WHERE paaf.person_id = p_person_id
159: AND paaf.payroll_id = papf.payroll_id
160: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 1692: pay_all_payrolls_f papf,

1688: /* check person does not hold employment with the employer between start of year and archive end date */
1689: AND NOT EXISTS (
1690: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
1691: FROM per_all_assignments_f paf,
1692: pay_all_payrolls_f papf,
1693: hr_soft_coding_keyflex scl
1694: WHERE paf.person_id = as1.person_id
1695: AND paf.payroll_id = papf.payroll_id
1696: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to