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_CA_T4_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 158: per_all_assignments_f paf,

154: paf.effective_end_date,
155: paa.assignment_action_id
156: FROM pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: per_all_assignments_f paf,
159: pay_payroll_actions ppa1
160: WHERE ppa1.payroll_action_id = p_pactid
161: AND ppa.report_type = 'T4'
162: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 184: FROM per_all_assignments_f paf2

180: AND paf.assignment_type = 'E'
181: AND paf.effective_start_date <= ppa.effective_date
182: AND paf.effective_end_date >= ppa.start_date
183: AND paf.effective_end_date = (SELECT MAX(paf2.effective_end_date)
184: FROM per_all_assignments_f paf2
185: WHERE paf2.assignment_id = paf.assignment_id
186: AND paf2.effective_start_date <= ppa.effective_date )
187: ORDER BY paf.person_id;
188: