APPS.BIS_WORKFLOW_PROCESS_PVT SQL Statements

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

Line: 15

         select wf.name,
                wf.display_name
         from wf_item_types_vl wf
         where wf.name like '%BISW%'
         order by wf.name;

Line: 42

         select wf.item_type,
                wf.name ,
                wf.display_name
         from wf_activities_vl wf
         where wf.item_type like '%BISW%'
         and type = 'PROCESS'
         and wf.begin_date <= sysdate
         and NVL(wf.end_date,sysdate) >= sysdate
         order by wf.item_type;

Line: 98

    select wf.display_name
    into x_wf_process_name
    from wf_activities_vl wf
    where wf.item_type = 'BISKPIWF'
    and type = 'PROCESS'
    and wf.name = p_wf_process_short_name
    and wf.begin_date <= sysdate
    and NVL(wf.end_date,sysdate) >= sysdate;

Line: 141

  select 1
  from wf_activities_vl wf
  where wf.item_type like '%BISW%'
  and type = 'PROCESS'
  and wf.name = p_wf_process_short_name
  and wf.begin_date <= sysdate
  and NVL(wf.end_date,sysdate) >= sysdate;

Line: 205

    select wf.name
      into x_wf_process_short_name
      from wf_activities_vl wf
      where wf.item_type = 'BISKPIWF'
      and type = 'PROCESS'
      and wf.display_name = p_wf_process_name
      and wf.begin_date <= sysdate
      and NVL(wf.end_date,sysdate) >= sysdate;