APPS.WF_ACTIVITY dependencies on WF_ACTIVITIES

Line 117: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
116:
117: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
118:
119: where WPA.INSTANCE_ID = actid
120: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
121: and WA.NAME = WPA.ACTIVITY_NAME

Line 236: from WF_ACTIVITIES WA

232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION
235:
236: from WF_ACTIVITIES WA
237: where WA.ITEM_TYPE = itemtype
238: and WA.NAME = activity
239: and actdate >= WA.BEGIN_DATE
240: and actdate < nvl(WA.END_DATE, actdate+1);

Line 614: from WF_ACTIVITIES WA

610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION
613:
614: from WF_ACTIVITIES WA
615: where WA.ITEM_TYPE = itemtype
616: and WA.NAME = activity
617: and actdate >= WA.BEGIN_DATE
618: and actdate < nvl(WA.END_DATE, actdate+1);