APPS.POR_AME_REQ_WF_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 626: SELECT assignment_status_type_id FROM per_assignment_status_types

622: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
623: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
624: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
625: and asg.assignment_status_type_id not in (
626: SELECT assignment_status_type_id FROM per_assignment_status_types
627: WHERE per_system_status = 'TERM_ASSIGN'
628: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
629: ) where rownum = 1;
630:

Line 1426: SELECT assignment_status_type_id FROM per_assignment_status_types

1422: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1423: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1424: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1425: and asg.assignment_status_type_id not in (
1426: SELECT assignment_status_type_id FROM per_assignment_status_types
1427: WHERE per_system_status = 'TERM_ASSIGN'
1428: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
1429: ) where rownum = 1;
1430:

Line 3276: SELECT assignment_status_type_id FROM per_assignment_status_types

3272: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3273: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3274: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
3275: and asg.assignment_status_type_id not in (
3276: SELECT assignment_status_type_id FROM per_assignment_status_types
3277: WHERE per_system_status = 'TERM_ASSIGN'
3278: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
3279: ) where rownum = 1;
3280: