APPS.WF_PROCESS_ACTIVITY dependencies on WF_ACTIVITIES

Line 70: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A

66: actdate := Wf_Item.Active_Date(itemtype, itemkey);
67:
68: select INSTANCE_ID
69: into instid
70: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
71: where A.ITEM_TYPE = itemtype
72: and A.NAME = 'ROOT'
73: and actdate >= A.BEGIN_DATE
74: and actdate < NVL(A.END_DATE, actdate+1)

Line 325: WF_ACTIVITIES WA,

321: is
322: cursor curs(parentid in pls_integer, actdate in date) is
323: select WPA2.INSTANCE_ID, WPA2.ACTIVITY_ITEM_TYPE, WPA2.ACTIVITY_NAME
324: from WF_PROCESS_ACTIVITIES WPA1,
325: WF_ACTIVITIES WA,
326: WF_PROCESS_ACTIVITIES WPA2
327: where WPA1.INSTANCE_ID = parentid
328: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
329: and WPA2.PROCESS_NAME = WA.NAME

Line 387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:
387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
388:
389: where WPA.INSTANCE_ID = rootid
390: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
391: and WA.NAME = WPA.ACTIVITY_NAME

Line 419: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

415: -- Get root id for the error process
416: begin
417: select WPA.INSTANCE_ID
418: into errid
419: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
420: where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE
421: and WPA.PROCESS_NAME = 'ROOT'
422: and WPA.PROCESS_VERSION = WA.VERSION
423: and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE

Line 514: WF_ACTIVITIES WA,

510:
511: cursor curs(parentid in pls_integer, actdate in date) is
512: select WPA2.PROCESS_NAME, WPA2.INSTANCE_ID, WPA2.INSTANCE_LABEL
513: from WF_PROCESS_ACTIVITIES WPA1,
514: WF_ACTIVITIES WA,
515: WF_PROCESS_ACTIVITIES WPA2
516: where WPA1.INSTANCE_ID = parentid
517: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
518: and WPA2.PROCESS_NAME = WA.NAME