The following lines contain the word 'select', 'insert', 'update' or 'delete':
select INSTANCE_ID
into instid
from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
where A.ITEM_TYPE = itemtype
and A.NAME = 'ROOT'
and actdate >= A.BEGIN_DATE
and actdate < NVL(A.END_DATE, actdate+1)
and PA.PROCESS_NAME = 'ROOT'
and PA.PROCESS_ITEM_TYPE = itemtype
and PA.PROCESS_VERSION = A.VERSION
and PA.INSTANCE_LABEL = process;
select 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.ProcessActivities(actid)
from WF_PROCESS_ACTIVITIES WPA
where WPA.INSTANCE_ID = actid;
select
WPA.INSTANCE_ID
into instid
from WF_PROCESS_ACTIVITIES WPA
where WPA.INSTANCE_LABEL = StartInstanceId.label
and WPA.PROCESS_ITEM_TYPE = StartInstanceId.itemtype
and WPA.PROCESS_NAME = StartInstanceId.process
and WPA.PROCESS_VERSION = StartInstanceId.version
and WPA.START_END = wf_engine.eng_start;
select WPA.INSTANCE_ID
into instid
from WF_PROCESS_ACTIVITIES WPA
where WPA.INSTANCE_LABEL = activeinstanceid.label
and WPA.PROCESS_NAME = nvl(activeinstanceid.process, WPA.PROCESS_NAME)
and WPA.INSTANCE_ID = activeinstanceid.cur_actid;
select WPA.INSTANCE_ID
into instid
from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
where WIAS.ITEM_TYPE = activeinstanceid.itemtype
and WIAS.ITEM_KEY = activeinstanceid.itemkey
and WIAS.ACTIVITY_STATUS = nvl(activeinstanceid.status,
WIAS.ACTIVITY_STATUS)
and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
and WPA.INSTANCE_LABEL = activeinstanceid.label
and WPA.PROCESS_NAME = nvl(activeinstanceid.process, WPA.PROCESS_NAME);
select WPA2.INSTANCE_ID, WPA2.ACTIVITY_ITEM_TYPE, WPA2.ACTIVITY_NAME
from WF_PROCESS_ACTIVITIES WPA1,
WF_ACTIVITIES WA,
WF_PROCESS_ACTIVITIES WPA2
where WPA1.INSTANCE_ID = parentid
and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
and WPA2.PROCESS_NAME = WA.NAME
and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE
and WA.NAME = WPA1.ACTIVITY_NAME
and actdate >= WA.BEGIN_DATE
and actdate < NVL(WA.END_DATE, actdate+1)
and WPA2.PROCESS_VERSION = WA.VERSION;
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(rootid).PROCESS_ITEM_TYPE,
WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
WF_CACHE.ProcessActivities(rootid).START_END,
WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
where WPA.INSTANCE_ID = rootid
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);
select WPA.INSTANCE_ID
into errid
from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE
and WPA.PROCESS_NAME = 'ROOT'
and WPA.PROCESS_VERSION = WA.VERSION
and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
and WA.NAME = WPA.PROCESS_NAME
and actdate >= WA.BEGIN_DATE
and actdate < NVL(WA.END_DATE, actdate+1)
and WPA.INSTANCE_LABEL = WF_CACHE.Activities(waIND).ERROR_PROCESS;
select WPA2.PROCESS_NAME, WPA2.INSTANCE_ID, WPA2.INSTANCE_LABEL
from WF_PROCESS_ACTIVITIES WPA1,
WF_ACTIVITIES WA,
WF_PROCESS_ACTIVITIES WPA2
where WPA1.INSTANCE_ID = parentid
and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
and WPA2.PROCESS_NAME = WA.NAME
and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE
and WA.NAME = WPA1.ACTIVITY_NAME
and actdate >= WA.BEGIN_DATE
and actdate < NVL(WA.END_DATE, actdate+1)
and WPA2.PROCESS_VERSION = WA.VERSION;
select 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.ProcessActivities(parentid)
from WF_PROCESS_ACTIVITIES WPA
where WPA.INSTANCE_ID = parentid;