DBA Data[Home] [Help]

APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITIES_HISTORY_V

Line 1411: FROM WF_ITEM_ACTIVITIES_HISTORY_V

1407: -- Bug 5223211 : start
1408: /*
1409: CURSOR CUR_NOTIFICATION IS
1410: SELECT NOTIFICATION_ID
1411: FROM WF_ITEM_ACTIVITIES_HISTORY_V
1412: WHERE ITEM_KEY = p_itemkey
1413: AND ITEM_TYPE = p_itemtype
1414: AND ACTIVITY_TYPE = 'NOTICE'
1415: AND NOTIFICATION_STATUS = 'OPEN'

Line 1956: from WF_ITEM_ACTIVITIES_HISTORY_V

1952: p_item_key out NOCOPY varchar2,
1953: p_item_type out NOCOPY varchar2) is
1954: cursor getItemKey is
1955: select ITEM_KEY, ITEM_TYPE
1956: from WF_ITEM_ACTIVITIES_HISTORY_V
1957: where NOTIFICATION_ID = p_notif;
1958: BEGIN
1959: open getItemKey;
1960: fetch getItemKey into p_item_key,p_item_type;