APPS.PER_GB_TERMINATION dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 78: per_assignment_status_types typ
74: p_date_active date)
75: IS
76: SELECT assignment_id, assignment_number
77: FROM per_all_assignments_f asg, 78: per_assignment_status_types typ 79: WHERE asg.person_id = p_person_id
80: AND asg.period_of_service_id = p_period_of_service_id
81: AND asg.assignment_status_type_id = typ.assignment_status_type_id
82: AND typ.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')