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

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

239: tmpApprover.orig_system := ame_util.posOrigSystem;
240: SELECT position_id into tmpApprover.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
241: WHERE pa.person_id = pPersonId and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
242: and pa.position_id is not null and pa.assignment_status_type_id not in (
243: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
244: and TRUNC ( pa.effective_start_date )
245: <= TRUNC(SYSDATE) AND NVL(pa.effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE);
246:
247: if g_fnd_debug = 'Y' then

Line 1774: SELECT assignment_status_type_id FROM per_assignment_status_types

1770: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1771: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1772: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1773: and asg.assignment_status_type_id not in (
1774: SELECT assignment_status_type_id FROM per_assignment_status_types
1775: WHERE per_system_status = 'TERM_ASSIGN'
1776: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1777: ) where rownum = 1;
1778: exception

Line 2132: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

2128: FROM PER_ALL_ASSIGNMENTS_F
2129: WHERE PERSON_ID = l_preparer_id
2130: and primary_flag = 'Y'
2131: and assignment_type in ('E','C')
2132: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2133: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE)
2134: and NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2135: and rownum = 1;
2136: -- bug 14591082: added condition 'approversTableIn(i).approval_status = ame_util.approvedStatus'

Line 2255: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

2251: SELECT position_id, job_id INTO l_position_id, l_job_id
2252: FROM per_all_assignments_f
2253: WHERE person_id = l_person_id
2254: and primary_flag = 'Y' and assignment_type in ('E','C')
2255: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2256: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2257: and rownum = 1;
2258:
2259: if l_position_id is not null then

Line 2633: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

2629: SELECT position_id, job_id INTO l_position_id, l_job_id
2630: FROM per_all_assignments_f
2631: WHERE person_id = p_approver_id
2632: and primary_flag = 'Y' and assignment_type in ('E','C')
2633: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2634: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2635: and rownum = 1;
2636:
2637: if l_position_id is not null then

Line 3040: SELECT assignment_status_type_id FROM per_assignment_status_types

3036: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3037: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3038: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
3039: and asg.assignment_status_type_id not in (
3040: SELECT assignment_status_type_id FROM per_assignment_status_types
3041: WHERE per_system_status = 'TERM_ASSIGN'
3042: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
3043: ) where rownum = 1;
3044:

Line 3099: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

3095: FROM per_all_assignments_f
3096: WHERE person_id = l_person_id
3097: and (l_authorizationStatus = 'APPROVED'
3098: or (primary_flag = 'Y' and assignment_type in ('E','C')
3099: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
3100: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
3101: )
3102: )
3103: and rownum = 1;

Line 3396: FROM per_assignment_status_types

3392: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3393: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
3394: and asg.assignment_status_type_id not in (
3395: SELECT assignment_status_type_id
3396: FROM per_assignment_status_types
3397: WHERE per_system_status = 'TERM_ASSIGN'
3398: )
3399: and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
3400: order by person.last_name