APPS.EDR_ERES_EVENT_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

  select count(*)
  from wf_events_vl
  where name = p_event_name;

Line: 156

  SELECT COUNT(DOCUMENT_ID)
  FROM EDR_PSIG_DOCUMENTS
  WHERE DOCUMENT_ID = p_erecord_id;

Line: 307

     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')) ;

Line: 821

  SELECT EVENT_NAME, EVENT_KEY
  FROM EDR_PSIG_DOCUMENTS
  WHERE DOCUMENT_ID = p_erecord_id;