APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V

1437: AND NOTIFICATION_STATUS = 'OPEN'
1438: ORDER BY BEGIN_DATE DESC;
1439: */
1440: CURSOR CUR_NOTIFICATION IS
1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V
1442: WHERE ITEM_KEY = p_itemkey
1443: AND ITEM_TYPE = p_itemtype
1444: AND notification_id is not null
1445: ORDER BY activity_begin_date, execution_time;