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

Line 1168: , per_assignment_status_types past

1164: CURSOR c_all_assignments_payroll IS
1165: SELECT DISTINCT
1166: paaf.assignment_id
1167: FROM per_all_assignments_f paaf
1168: , per_assignment_status_types past
1169: WHERE paaf.payroll_id = p_payroll
1170: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1171: AND past.per_system_status = 'ACTIVE_ASSIGN'
1172: AND paaf.assignment_type = 'E'

Line 1689: , per_assignment_status_types past

1685: CURSOR c_all_assignments_payroll IS
1686: SELECT DISTINCT
1687: paaf.assignment_id
1688: FROM per_all_assignments_f paaf
1689: , per_assignment_status_types past
1690: WHERE paaf.payroll_id = p_payroll
1691: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1692: AND past.per_system_status = 'ACTIVE_ASSIGN'
1693: AND paaf.assignment_type = 'E'