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

Line 75: per_all_assignments_f paf,

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

Line 96: FROM per_all_assignments_f paf2

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

Line 178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

174: l_effective_end_date DATE;
175: l_report_type pay_payroll_actions.report_type%TYPE;
176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;