The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from wf_events_vl
where name = p_event_name;
SELECT COUNT(DOCUMENT_ID)
FROM EDR_PSIG_DOCUMENTS
WHERE DOCUMENT_ID = p_erecord_id;
select count(*) INTO l_no_enabled_eres_sub
from wf_events a, wf_event_subscriptions b
where a.GUID = b.EVENT_FILTER_GUID
and a.name = p_event_name
and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
and b.STATUS = 'ENABLED'
and b.source_type = 'LOCAL'
and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
SELECT EVENT_NAME, EVENT_KEY
FROM EDR_PSIG_DOCUMENTS
WHERE DOCUMENT_ID = p_erecord_id;