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

Line 369: from per_assignments_f paf,

365: ppf.first_name first_name,
366: ppf.national_identifier PPSN,
367: paf.assignment_number works_no,
368: pps.date_start hire_date
369: from per_assignments_f paf,
370: per_all_people_f ppf,
371: per_periods_of_service pps
372: where paf.person_id = ppf.person_id
373: and paf.assignment_id = cp_assignment_id

Line 1622: from per_assignments_f a,per_assignments_f b

1618: )
1619: AND as1.effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')
1620: )
1621: AND (as1.payroll_id in (select b.payroll_id
1622: from per_assignments_f a,per_assignments_f b
1623: where a.payroll_id = l_payroll_id
1624: and a.person_id = b.person_id
1625: and a.period_of_Service_id = b.period_of_Service_id
1626: and a.period_of_Service_id = as1.period_of_Service_id