DBA Data[Home] [Help]

APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 226: ** wf_item_activity_statuses_h. Hence added if condition

222:
223: /*FP 14058500
224: Fix for bug 7391797
225: ** When an activity is skipped the old data is moved to
226: ** wf_item_activity_statuses_h. Hence added if condition
227: ** to return the notification_id in this case
228: */
229:
230: IF (x_notification_id = -9995) THEN

Line 234: WF_ITEM_ACTIVITY_STATUSES_H WIAS

230: IF (x_notification_id = -9995) THEN
231: SELECT NVL(MAX(wf.notification_id), -9995)
232: INTO x_notification_id
233: FROM WF_NOTIFICATIONS WF,
234: WF_ITEM_ACTIVITY_STATUSES_H WIAS
235: WHERE WIAS.ITEM_TYPE = itemtype AND
236: WIAS.ITEM_KEY = itemkey AND
237: WIAS.NOTIFICATION_ID = WF.group_id;
238: END IF;