DBA Data[Home] [Help]

APPS.WF_PROCESS_ACTIVITY dependencies on WF_ITEM_ACTIVITY_STATUSES

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)