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 986: SELECT assignment_status_type_id FROM per_assignment_status_types

982: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
983: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
984: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
985: and asg.assignment_status_type_id not in (
986: SELECT assignment_status_type_id FROM per_assignment_status_types
987: WHERE per_system_status = 'TERM_ASSIGN'
988: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
989: ) where rownum = 1;
990: END IF;

Line 1477: SELECT assignment_status_type_id FROM per_assignment_status_types

1473: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1474: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1475: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1476: and asg.assignment_status_type_id not in (
1477: SELECT assignment_status_type_id FROM per_assignment_status_types
1478: WHERE per_system_status = 'TERM_ASSIGN'
1479: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1480: ) where rownum = 1;
1481: END IF;

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

1623: BEGIN
1624: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1625: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1626: and pa.position_id is not null and pa.assignment_status_type_id not in (
1627: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
1628: and TRUNC ( pa.effective_start_date )
1629: <= TRUNC(SYSDATE) AND NVL(pa.effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE);
1630: EXCEPTION
1631: WHEN OTHERS THEN

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

2016: BEGIN
2017: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2018: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2019: and pa.position_id is not null and pa.assignment_status_type_id not in (
2020: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2021: and TRUNC ( pa.effective_start_date )
2022: <= TRUNC(SYSDATE) AND NVL(pa.effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE);
2023: EXCEPTION
2024: WHEN OTHERS THEN