APPS.CSI_HANDLE_EVENT_PKG SQL Statements

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

Line: 12

      SELECT 'Y'
      FROM   wf_events              eve,
             wf_event_subscriptions sub,
   	     wf_systems             ws
      WHERE eve.name        = p_event_name
      AND   eve.status      = 'ENABLED'
      AND   eve.guid        = sub.event_filter_guid
      AND   sub.status      = 'ENABLED'
      AND   ws.guid         = sub.system_guid
      AND   sub.source_type = 'LOCAL';

Line: 42

      SELECT p_event_name || CSI_WF_ITEM_KEY_NUMBER_S.nextval
      INTO   RetKey
      FROM   DUAL;

Line: 56

      SELECT name
      INTO   RetEvent
      FROM   wf_events
      WHERE  name = p_event_name;