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_GB_RTI_P60 dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei

3915: -- Cursor to fetch the RTI NI Reporting assignment for this person.
3916: cursor csr_get_ni_rpt_asg(c_asg_id number) is
3917: select
3918: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
3920: where paaf1.assignment_id = c_asg_id
3921: and paaf1.person_id = paaf2.person_id
3922: and paaf2.assignment_status_type_id in(select ASSIGNMENT_STATUS_TYPE_ID from per_assignment_status_types past where past.LEGISLATION_CODE is null and past.BUSINESS_GROUP_ID is null
3923: and PER_SYSTEM_STATUS = 'ACTIVE_ASSIGN')