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

Line 1000: SELECT assignment_status_type_id FROM per_assignment_status_types

996: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
997: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
998: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
999: and asg.assignment_status_type_id not in (
1000: SELECT assignment_status_type_id FROM per_assignment_status_types
1001: WHERE per_system_status = 'TERM_ASSIGN'
1002: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1003: ) where rownum = 1;
1004: END IF;

Line 1512: SELECT assignment_status_type_id FROM per_assignment_status_types

1508: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1509: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1510: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1511: and asg.assignment_status_type_id not in (
1512: SELECT assignment_status_type_id FROM per_assignment_status_types
1513: WHERE per_system_status = 'TERM_ASSIGN'
1514: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1515: ) where rownum = 1;
1516: END IF;

Line 1662: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

1658: BEGIN
1659: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1660: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1661: and pa.position_id is not null and pa.assignment_status_type_id not in (
1662: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
1663: and TRUNC ( pa.effective_start_date )
1664: <= TRUNC(SYSDATE) AND NVL(pa.effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE);
1665: EXCEPTION
1666: WHEN OTHERS THEN

Line 2055: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

2051: BEGIN
2052: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2053: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2054: and pa.position_id is not null and pa.assignment_status_type_id not in (
2055: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2056: and TRUNC ( pa.effective_start_date )
2057: <= TRUNC(SYSDATE) AND NVL(pa.effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE);
2058: EXCEPTION
2059: WHEN OTHERS THEN