APPS.ECX_INBOUND_LISTENER_QH SQL Statements

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

Line: 63

  select ecx_trigger_id_s.NEXTVAL
  from dual;

Line: 73

  select upper(queue_name), upper(name), system_guid
  into   x_queue_name, x_agent_name, x_sys_guid      -- 20
  from   wf_agents
  where  guid = p_agent_guid;

Line: 78

  select upper(name)
  into   x_sys_name
  from   wf_systems
  where  guid = x_sys_guid;

Line: 148

  select ecx_inlstn_s.nextval into i_message_counter from dual ;