APPS.WF_PROCESS_ACTIVITY dependencies on WF_ITEM_ACTIVITY_STATUS

Line 252: Wf_Item_Activity_Status.LastResult(itemtype, itemkey,

248: -- because synch processes can only operate on the current activity.
249: --
250: if (itemkey = wf_engine.eng_synch) then
251: -- Get the current item and status in the cache
252: Wf_Item_Activity_Status.LastResult(itemtype, itemkey,
253: cur_actid, cur_status, cur_result);
254:
255: -- If status doesn't match one asked for, immediate trouble
256: if (nvl(status, '1') <> nvl(cur_status, '2')) then

Line 271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

267: else
268: -- NORMAL mode
269: select WPA.INSTANCE_ID
270: into instid
271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
272: where WIAS.ITEM_TYPE = activeinstanceid.itemtype
273: and WIAS.ITEM_KEY = activeinstanceid.itemkey
274: and WIAS.ACTIVITY_STATUS = nvl(activeinstanceid.status,
275: WIAS.ACTIVITY_STATUS)