APPS.WF_RULE SQL Statements

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

Line: 13

  select parameters into parm
  from   wf_event_subscriptions
  where  guid = p_subscription_guid;

Line: 101

  select source_type into srctype from wf_event_subscriptions
  where guid = p_subscription_guid;

Line: 214

  select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
         , parameters
  into   out_guid, to_guid, wftype, wfname, pri, subparams
  from   wf_event_subscriptions
  where  guid = p_subscription_guid;

Line: 224

      select wf_error_processes_s.nextval
      into lcorrid
      from dual;

Line: 248

      select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

Line: 342

  select wf_process_type,wf_process_name,priority,parameters
  into   wftype, wfname, pri, param
  from   wf_event_subscriptions
  where  guid = p_subscription_guid;

Line: 376

      select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

Line: 416

  select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
  into   out_guid, to_guid, wftype, wfname, pri
  from   wf_event_subscriptions
  where  guid = p_subscription_guid;

Line: 432

      select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

Line: 499

  SELECT  parameters
  FROM    wf_event_subscriptions
  WHERE   guid = p_subscription_guid;

Line: 749

  select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
         , parameters
  into   out_guid, to_guid, wftype, wfname, pri, subparams
  from   wf_event_subscriptions
  where  guid = p_subscription_guid;

Line: 835

   select to_char(sysdate, timeMask)
   into generateTime
   from sys.dual;