The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name
into l_name
from per_jobs_vl
where job_id = p_job_id;
select name
into l_name
from per_positions
where position_id = p_pos_id;
select name
into l_name
from per_grades_vl
where grade_id = p_grade_id;
select location_code
into l_location
from hr_locations_all_tl
where location_id = p_loc_id
and language = userenv('LANG');
select pay_basis
into l_basis
from per_pay_bases
where pay_basis_id = p_pay_id;
select payroll_name
into l_payroll
from pay_payrolls_f
where payroll_id = p_payroll_id
and sysdate between effective_start_date
and effective_end_date;