The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 76
select max(priority)
into priority
from pay_personal_payment_methods_f
where assignment_id = p_assignment_id
and trunc(hr_adp.get_adp_extract_date)
between effective_start_date
and effective_end_date ;