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_NZ_EMS dependencies on PER_ASSIGNMENTS_F

Line 215: , per_assignments_f a

211: b.child_support_deductions,b.student_loan_deductions)),-1,0 /* Bug No : 2755544 */
212: ,decode(sign(b.gross_earnings - (b.paye_deductions + b.child_support_deductions + b.student_loan_deductions)),-1,0,1)) flag
213: from hr_organization_units ou /*Bug No 2920728*/
214: , per_people_f p /*Bug No 2920728*/
215: , per_assignments_f a
216: , hr_soft_coding_keyflex scl
217: , pay_nz_asg_cal_mth_bal_v b
218: , pay_element_types_f et
219: , pay_input_values_f iv

Line 265: from per_assignments_f a2

261: and a.effective_start_date <= last_day(s.effective_date)
262: and a.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
263: -- the following sub query makes sure that we get the assignment in effect at the end of the month
264: and a.effective_start_date = (select max(a2.effective_start_date)
265: from per_assignments_f a2
266: where a2.person_id = a.person_id
267: and a2.assignment_id = a.assignment_id
268: and a2.effective_start_date <= last_day(s.effective_date)
269: )