The following lines contain the word 'select', 'insert', 'update' or 'delete':
select meaning
into HP_ORDER_BY
from ar_lookups
where lookup_type = 'ARXNROPN_ORDER_BY'
and lookup_code = P_ORDER_BY;
select bank_account_num
into HP_BANK_ACCOUNT
from ce_bank_accounts
where bank_account_id = P_BANK_ACCOUNT_ID;
select meaning
into HP_NOTE_STATUS
from ar_lookups
where lookup_type = decode(P_NOTE_STATUS,
'REMITTED', 'RECEIPT_CREATION_STATUS',
'AR_NOTE_STATUS')
and lookup_code = P_NOTE_STATUS;