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.PA_RESOURCE_UTILS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1689: FROM per_assignment_status_types past

1685: AND pep.effective_end_date
1686: AND primary_flag = 'Y'
1687: AND assignment_type in ('C', 'E') /* added for bug 2745823 */
1688: AND ((SELECT per_system_status
1689: FROM per_assignment_status_types past
1690: WHERE past.assignment_status_type_id = assn.assignment_status_type_id) IN ('ACTIVE_ASSIGN','ACTIVE_CWK')); --Bug#8879958
1691:
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN

Line 3870: per_assignment_status_types status,

3866: cursor get_active_assignment
3867: is
3868: select asgn.assignment_id
3869: from per_all_assignments_f asgn,
3870: per_assignment_status_types status,
3871: (select person_id, actual_termination_date
3872: from per_periods_of_service
3873: union all
3874: select person_id, actual_termination_date