The following lines contain the word 'select', 'insert', 'update' or 'delete':
select set_of_books_id, invoice_date
into l_sob_id, l_inv_date
from ap_invoices_all
where invoice_id = l_invoice_id;
select period_name
into l_period_name
from gl_period_statuses
where application_id = 200
and set_of_books_id = l_sob_id
and l_inv_Date between start_date and end_date;
select APS.set_of_books_id, AC.check_date
into l_sob_id, l_check_date
from ap_checks_all AC, ap_system_parameters_all APS
where check_id = l_check_id
and AC.org_id = APS.org_id;
select period_name
into l_period_name
from gl_period_statuses
where application_id = 200
and set_of_books_id = l_sob_id
and l_check_date between start_date and end_date;