APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 46: from per_assignment_status_types s

42: from per_assignments_f a
43: where a.assignment_id = P_ASS_ID
44: and a.effective_start_date > P_SESS_DATE
45: and exists (select null
46: from per_assignment_status_types s
47: where s.assignment_status_type_id =
48: a.assignment_status_type_id
49: and s.per_system_status <> 'TERM_ASSIGN');
50: begin