APPS.WF_EVENT_OJMSTEXT_QH SQL Statements

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

Line: 798

   select wfa.queue_name into l_out_queue_name
   from wf_agents wfa,
        wf_systems wfs
   where wfa.name = l_out_agent_name
   and wfs.name = l_out_system_name
   and wfs.guid = wfa.system_guid;

Line: 971

   select upper(queue_name),
          upper(name)
   into l_queue_name,
        l_agent_name
   from wf_agents
   where guid = p_agent_guid;