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_NO_EOY_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 652: ,per_assignment_status_types pas

648: ,least( p_effective_date, paf.effective_end_date) end_date
649: FROM per_all_assignments_f paf
650: ,hr_soft_coding_keyflex sck
651: ,hr_organization_information hoi
652: ,per_assignment_status_types pas
653: WHERE paf.person_id = p_person_id
654: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
655: AND pas.assignment_status_type_id = paf.assignment_status_type_id
656: AND pas.user_status = 'Active Assignment'

Line 752: ,per_assignment_status_types pas

748: ,least( p_effective_date, paf.effective_end_date) end_date
749: FROM per_all_assignments_f paf
750: ,hr_soft_coding_keyflex sck
751: ,hr_organization_information hoi
752: ,per_assignment_status_types pas
753: WHERE paf.person_id = p_person_id
754: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
755: AND pas.assignment_status_type_id = paf.assignment_status_type_id
756: AND pas.user_status = 'Active Assignment'