APPS.WF_ACTIVITY SQL Statements

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

Line: 81

    select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
           WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS,
           WA.FUNCTION, WA.FUNCTION_TYPE, WA.MESSAGE, WA.BEGIN_DATE,
           WA.END_DATE, WA.DIRECTION, WPA.PROCESS_ITEM_TYPE,
           WPA.PROCESS_NAME, WPA.PROCESS_VERSION, WPA.ACTIVITY_ITEM_TYPE,
           WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL,
           WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
           WPA.DEFAULT_RESULT

    into   WF_CACHE.Activities(waIND).ITEM_TYPE,
           WF_CACHE.Activities(waIND).NAME,
           WF_CACHE.Activities(waIND).VERSION,
           WF_CACHE.Activities(waIND).TYPE,
           WF_CACHE.Activities(waIND).RERUN,
           WF_CACHE.Activities(waIND).EXPAND_ROLE,
           WF_CACHE.Activities(waIND).COST,
           WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
           WF_CACHE.Activities(waIND).ERROR_PROCESS,
           WF_CACHE.Activities(waIND).FUNCTION,
           WF_CACHE.Activities(waIND).FUNCTION_TYPE,
           WF_CACHE.Activities(waIND).MESSAGE,
           WF_CACHE.Activities(waIND).BEGIN_DATE,
           WF_CACHE.Activities(waIND).END_DATE,
           WF_CACHE.Activities(waIND).DIRECTION,
           WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
           WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
           WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
           WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
           WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
           WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
           WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
           WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
           WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
           WF_CACHE.ProcessActivities(actid).START_END,
           WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

    from   WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

    where  WPA.INSTANCE_ID = actid
    and    WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
    and    WA.NAME = WPA.ACTIVITY_NAME
    and    actdate >= WA.BEGIN_DATE
    and    actdate < NVL(WA.END_DATE, actdate+1);

Line: 214

    select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
           WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE,
           WA.ERROR_PROCESS, WA.FUNCTION, WA.FUNCTION_TYPE,  WA.EVENT_NAME,
           WA.MESSAGE, WA.BEGIN_DATE, WA.END_DATE, WA.DIRECTION

    into   WF_CACHE.Activities(waIND).ITEM_TYPE,
           WF_CACHE.Activities(waIND).NAME,
           WF_CACHE.Activities(waIND).VERSION,
           WF_CACHE.Activities(waIND).TYPE,
           WF_CACHE.Activities(waIND).RERUN,
           WF_CACHE.Activities(waIND).EXPAND_ROLE,
           WF_CACHE.Activities(waIND).COST,
           WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
           WF_CACHE.Activities(waIND).ERROR_PROCESS,
           WF_CACHE.Activities(waIND).FUNCTION,
           WF_CACHE.Activities(waIND).FUNCTION_TYPE,
           WF_CACHE.Activities(waIND).EVENT_NAME,
           WF_CACHE.Activities(waIND).MESSAGE,
           WF_CACHE.Activities(waIND).BEGIN_DATE,
           WF_CACHE.Activities(waIND).END_DATE,
           WF_CACHE.Activities(waIND).DIRECTION

    from   WF_ACTIVITIES WA
    where  WA.ITEM_TYPE = itemtype
    and    WA.NAME = activity
    and    actdate >= WA.BEGIN_DATE
    and    actdate < nvl(WA.END_DATE, actdate+1);

Line: 528

  select
    WIAS.ASSIGNED_USER
  into assuser
  from WF_ITEM_ACTIVITY_STATUSES WIAS
  where WIAS.ITEM_TYPE = itemtype
  and WIAS.ITEM_KEY = itemkey
  and WIAS.PROCESS_ACTIVITY = actid;

Line: 592

    select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN, WA.EXPAND_ROLE,
           WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS, WA.FUNCTION,
           WA.FUNCTION_TYPE, WA.EVENT_NAME, WA.MESSAGE, WA.BEGIN_DATE,
           WA.END_DATE, WA.DIRECTION

    into   WF_CACHE.Activities(waIND).ITEM_TYPE,
           WF_CACHE.Activities(waIND).NAME,
           WF_CACHE.Activities(waIND).VERSION,
           WF_CACHE.Activities(waIND).TYPE,
           WF_CACHE.Activities(waIND).RERUN,
           WF_CACHE.Activities(waIND).EXPAND_ROLE,
           WF_CACHE.Activities(waIND).COST,
           WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
           WF_CACHE.Activities(waIND).ERROR_PROCESS,
           WF_CACHE.Activities(waIND).FUNCTION,
           WF_CACHE.Activities(waIND).FUNCTION_TYPE,
           WF_CACHE.Activities(waIND).EVENT_NAME,
           WF_CACHE.Activities(waIND).MESSAGE,
           WF_CACHE.Activities(waIND).BEGIN_DATE,
           WF_CACHE.Activities(waIND).END_DATE,
           WF_CACHE.Activities(waIND).DIRECTION

    from   WF_ACTIVITIES WA
    where  WA.ITEM_TYPE = itemtype
    and    WA.NAME = activity
    and    actdate >= WA.BEGIN_DATE
    and    actdate < nvl(WA.END_DATE, actdate+1);