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

1705: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1706: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1707: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1708: and asg.assignment_status_type_id not in (
1709: SELECT assignment_status_type_id FROM per_assignment_status_types
1710: WHERE per_system_status = 'TERM_ASSIGN'
1711: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1712: ) where rownum = 1;
1713: exception

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

2059: FROM PER_ALL_ASSIGNMENTS_F
2060: WHERE PERSON_ID = l_preparer_id
2061: and primary_flag = 'Y'
2062: and assignment_type in ('E','C')
2063: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2064: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE)
2065: and NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2066: and rownum = 1;
2067:

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

2181: SELECT position_id, job_id INTO l_position_id, l_job_id
2182: FROM per_all_assignments_f
2183: WHERE person_id = l_person_id
2184: and primary_flag = 'Y' and assignment_type in ('E','C')
2185: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2186: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2187: and rownum = 1;
2188:
2189: if l_position_id is not null then

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

2559: SELECT position_id, job_id INTO l_position_id, l_job_id
2560: FROM per_all_assignments_f
2561: WHERE person_id = p_approver_id
2562: and primary_flag = 'Y' and assignment_type in ('E','C')
2563: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2564: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2565: and rownum = 1;
2566:
2567: if l_position_id is not null then

Line 2970: SELECT assignment_status_type_id FROM per_assignment_status_types

2966: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
2967: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
2968: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
2969: and asg.assignment_status_type_id not in (
2970: SELECT assignment_status_type_id FROM per_assignment_status_types
2971: WHERE per_system_status = 'TERM_ASSIGN'
2972: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
2973: ) where rownum = 1;
2974:

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

3021: SELECT position_id, job_id INTO l_position_id, l_job_id
3022: FROM per_all_assignments_f
3023: WHERE person_id = l_person_id
3024: and primary_flag = 'Y' and assignment_type in ('E','C')
3025: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
3026: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
3027: and rownum = 1;
3028:
3029: if l_position_id is not null then

Line 3320: FROM per_assignment_status_types

3316: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3317: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
3318: and asg.assignment_status_type_id not in (
3319: SELECT assignment_status_type_id
3320: FROM per_assignment_status_types
3321: WHERE per_system_status = 'TERM_ASSIGN'
3322: )
3323: and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
3324: order by person.last_name