APPS.PER_GB_REVERSE_TERM_RULES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

SELECT paaf.assignment_id,
		 paaf.assignment_number
FROM     per_all_assignments_f  paaf,
         per_assignment_status_types past
WHERE  paaf.person_id = p_person_id
and p_actual_termination_date between paaf.effective_start_date and paaf.effective_end_date
AND paaf.assignment_status_type_id = past.assignment_status_type_id
AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN');