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

Line 199: per_all_assignments_f paf,

195: paf.effective_end_date,
196: paa.assignment_action_id
197: FROM pay_payroll_actions ppa,
198: pay_assignment_actions paa,
199: per_all_assignments_f paf,
200: pay_payroll_actions ppa1,
201: hr_organization_information hoi1
202: WHERE ppa1.payroll_action_id = p_pactid
203: AND ppa.report_type = 'T4A'

Line 220: FROM per_all_assignments_f paf2

216: AND paf.person_id BETWEEN p_stperson and p_endperson
217: AND paf.effective_start_date <= ppa.effective_date
218: AND paf.effective_end_date >= ppa.start_date
219: AND paf.effective_end_date = (SELECT MAX(paf2.effective_end_date)
220: FROM per_all_assignments_f paf2
221: WHERE paf2.assignment_id = paf.assignment_id
222: AND paf2.effective_start_date <= ppa.effective_date);
223:
224: