DBA Data[Home] [Help]

APPS.ONT_OEXOEWFR_XMLP_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 289: WF_ITEM_ACTIVITY_STATUSES WIAS,

285: CURSOR GET_LINE_DATE IS
286: SELECT
287: WIAS.END_DATE
288: FROM
289: WF_ITEM_ACTIVITY_STATUSES WIAS,
290: WF_PROCESS_ACTIVITIES WPA
291: WHERE WIAS.ITEM_TYPE = 'OEOL'
292: AND WIAS.ITEM_KEY = TO_CHAR(LINE_ID)
293: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 299: WF_ITEM_ACTIVITY_STATUSES WIAS,

295: CURSOR GET_HEADER_DATE IS
296: SELECT
297: WIAS.END_DATE
298: FROM
299: WF_ITEM_ACTIVITY_STATUSES WIAS,
300: WF_PROCESS_ACTIVITIES WPA
301: WHERE WIAS.ITEM_TYPE = 'OEOH'
302: AND WIAS.ITEM_KEY = TO_CHAR(HEADER_ID1)
303: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID