The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hr_ki_be_s.nextval INTO l_event_key FROM dual;
select etd.confirmation
into l_enabled
from ecx_tp_headers_v eth
,ecx_tp_details_v etd
where eth.tp_header_id=etd.tp_header_id
and eth.party_id = l_party_id
and eth.party_site_id =l_party_site_id
and etd.transaction_type=l_trans_type
and etd.transaction_subtype=l_trans_subtype;