APPS.WF_ENGINE dependencies on WF_ACTIVITY_ATTR_VALUES

Line 31: from WF_ACTIVITY_ATTR_VALUES WAAV

27: -- Optimizing the code using a single cursor with binds
28: cursor curs_activityattr (c_actid NUMBER, c_aname VARCHAR2) is
29: select WAAV.PROCESS_ACTIVITY_ID, WAAV.NAME, WAAV.VALUE_TYPE,
30: WAAV.TEXT_VALUE, WAAV.NUMBER_VALUE, WAAV.DATE_VALUE
31: from WF_ACTIVITY_ATTR_VALUES WAAV
32: where WAAV.PROCESS_ACTIVITY_ID = c_actid
33: and WAAV.NAME = c_aname;
34:
35: --

Line 7002: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,

6998: AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
6999: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
7000: AND WPA.ACTIVITY_NAME = WA.NAME
7001: AND EXISTS
7002: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,
7003: WF_ITEM_ATTRIBUTE_VALUES WIAV
7004: WHERE WAAV.PROCESS_ACTIVITY_ID = WIAS.PROCESS_ACTIVITY
7005: AND WAAV.NAME = '#BUSINESS_KEY'
7006: AND WAAV.VALUE_TYPE = 'ITEMATTR'