APPS.AR_CMGT_EVENT_PKG SQL Statements

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

Line: 7

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

Line: 44

   SELECT name
     FROM wf_events
    WHERE name = p_event_name;