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.HR_US_W4_EX dependencies on PAY_PAYROLL_ACTIONS

Line 97: pay_payroll_actions ppa,

93: CURSOR c_get_latest_asg(p_person_id number ) IS
94: select paa.assignment_action_id
95: from pay_assignment_actions paa,
96: per_all_assignments_f paf,
97: pay_payroll_actions ppa,
98: pay_action_classifications pac
99: where paf.person_id = p_person_id
100: and paa.assignment_id = paf.assignment_id
101: and paa.tax_unit_id = w4_tax_unit_id

Line 143: pay_payroll_actions ppa2,

139: select paa1.assignment_action_id
140: into l_bal_aaid
141: from pay_assignment_actions paa1,
142: per_assignments_f paf2,
143: pay_payroll_actions ppa2,
144: pay_action_classifications pac2
145: where paf2.person_id = w4_person_id
146: and paa1.assignment_id = paf2.assignment_id
147: and paa1.tax_unit_id = w4_tax_unit_id

Line 157: pay_payroll_actions ppa,

153: and ppa2.effective_date between w4_start_date and
154: w4_end_date
155: and not exists (select ''
156: FROM pay_action_classifications pac,
157: pay_payroll_actions ppa,
158: pay_assignment_actions paa,
159: per_assignments_f paf1
160: WHERE paf1.person_id = w4_person_id
161: AND paa.assignment_id = paf1.assignment_id