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

Line 77: per_all_assignments_f paf,

73: paf.effective_end_date,
74: MAX(paa.assignment_action_id)
75: FROM pay_payroll_actions ppa,
76: pay_assignment_actions paa,
77: per_all_assignments_f paf,
78: pay_payroll_actions ppa1,
79: hr_organization_information hoi1
80: WHERE ppa1.payroll_action_id = p_pactid
81: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP'

Line 98: FROM per_all_assignments_f paf2

94: AND paf.person_id BETWEEN p_stperson AND p_endperson
95: AND paf.effective_start_date <= ppa.effective_date
96: AND paf.effective_end_date >= ppa.start_date
97: AND paf.effective_end_date = (SELECT MAX(paf2.effective_end_date)
98: FROM per_all_assignments_f paf2
99: WHERE paf2.assignment_id = paf.assignment_id
100: AND paf2.effective_start_date <= ppa.effective_date)
101: AND NOT EXISTS
102: (SELECT pail.locked_action_id