The following lines contain the word 'select', 'insert', 'update' or 'delete':
select XSID
into l_XSID
from ICX_SESSIONS
where SESSION_ID = p_session_id;
select SESSION_ID
into l_SessionID
from ICX_SESSIONS
where XSID = p_XSID;
select TRANSACTION_ID
into l_TransactionID
from ICX_TRANSACTIONS
where TRANSACTION_ID = p_XTID;
select MAC_KEY
into l_key
from ICX_SESSIONS
where SESSION_ID = p_session_id;