APPS.POR_AME_REQ_WF_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 458: SELECT assignment_status_type_id FROM per_assignment_status_types

454: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
455: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
456: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
457: and asg.assignment_status_type_id not in (
458: SELECT assignment_status_type_id FROM per_assignment_status_types
459: WHERE per_system_status = 'TERM_ASSIGN'
460: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
461: ) where rownum = 1;
462:

Line 956: SELECT assignment_status_type_id FROM per_assignment_status_types

952: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
953: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
954: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
955: and asg.assignment_status_type_id not in (
956: SELECT assignment_status_type_id FROM per_assignment_status_types
957: WHERE per_system_status = 'TERM_ASSIGN'
958: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
959: ) where rownum = 1;
960:

Line 2239: SELECT assignment_status_type_id FROM per_assignment_status_types

2235: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
2236: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
2237: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
2238: and asg.assignment_status_type_id not in (
2239: SELECT assignment_status_type_id FROM per_assignment_status_types
2240: WHERE per_system_status = 'TERM_ASSIGN'
2241: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date order by person.last_name
2242: ) where rownum = 1;
2243: