APPS.HZ_EVENT_PKG SQL Statements

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

Line: 73

   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 UPPER(sub.rule_function) = 'HZ_EVENT_ELT.HZ_PARAM_DELETE'
      AND sub.status = 'ENABLED'
      AND ws.GUID = sub.SYSTEM_GUID
      AND sub.source_type = 'LOCAL';

Line: 103

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

Line: 115

   SELECT name INTO RetEvent
     FROM wf_events
    WHERE name = p_event_name;