APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITY_STATUSES_V
Line 1419: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V
1415: AND NOTIFICATION_STATUS = 'OPEN'
1416: ORDER BY BEGIN_DATE DESC;
1417: */
1418: CURSOR CUR_NOTIFICATION IS 1419: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V 1420: WHERE ITEM_KEY = p_itemkey
1421: AND ITEM_TYPE = p_itemtype
1422: AND notification_id is not null
1423: ORDER BY activity_begin_date, execution_time;