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 168: , per_assignments_f a

164: b.child_support_deductions,b.student_loan_deductions)),-1,0 /* Bug No : 2755544 */
165: ,decode(sign(b.gross_earnings - (b.paye_deductions + b.child_support_deductions + b.student_loan_deductions)),-1,0,1)) flag
166: from hr_organization_units ou /*Bug No 2920728*/
167: , per_people_f p /*Bug No 2920728*/
168: , per_assignments_f a
169: , hr_soft_coding_keyflex scl
170: , pay_nz_asg_cal_mth_bal_v b
171: , pay_element_types_f et
172: , pay_input_values_f iv

Line 218: from per_assignments_f a2

214: and a.effective_start_date <= last_day(s.effective_date)
215: and a.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
216: -- the following sub query makes sure that we get the assignment in effect at the end of the month
217: and a.effective_start_date = (select max(a2.effective_start_date)
218: from per_assignments_f a2
219: where a2.person_id = a.person_id
220: and a2.assignment_id = a.assignment_id
221: and a2.effective_start_date <= last_day(s.effective_date)
222: )