APPS.PO_AME_WF_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 548: FROM per_assignment_status_types

544: AND asg.assignment_type IN ( 'E', 'C' )
545: AND ( person.current_employee_flag = 'Y' OR person.current_npw_flag = 'Y' )
546: AND asg.assignment_status_type_id NOT IN
547: ( SELECT assignment_status_type_id
548: FROM per_assignment_status_types
549: WHERE per_system_status = 'TERM_ASSIGN' )
550: AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
551: ORDER BY person.last_name)
552: WHERE ROWNUM = 1;

Line 873: FROM per_assignment_status_types

869: AND asg.assignment_type IN ('E','C')
870: AND ( person.current_employee_flag = 'Y' OR person.current_npw_flag = 'Y' )
871: AND asg.assignment_status_type_id NOT IN
872: ( SELECT assignment_status_type_id
873: FROM per_assignment_status_types
874: WHERE per_system_status = 'TERM_ASSIGN'
875: )
876: AND TRUNC (sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date
877: ORDER BY person.last_name )

Line 3874: FROM per_assignment_status_types

3870: AND asg.assignment_type IN ( 'E', 'C' )
3871: AND ( person.current_employee_flag = 'Y' OR person.current_npw_flag = 'Y' )
3872: AND asg.assignment_status_type_id NOT IN
3873: (SELECT assignment_status_type_id
3874: FROM per_assignment_status_types
3875: WHERE per_system_status = 'TERM_ASSIGN' )
3876: AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
3877: ORDER BY person.last_name )
3878: WHERE ROWNUM = 1;

Line 5351: FROM per_assignment_status_types

5347: AND asg.assignment_type IN ('E','C')
5348: AND ( person.current_employee_flag = 'Y' OR person.current_npw_flag = 'Y' )
5349: AND asg.assignment_status_type_id NOT IN
5350: ( SELECT assignment_status_type_id
5351: FROM per_assignment_status_types
5352: WHERE per_system_status = 'TERM_ASSIGN'
5353: )
5354: AND TRUNC (sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date
5355: ORDER BY person.last_name )