DBA Data[Home] [Help]

APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITIES_HISTORY_V

Line 1433: FROM WF_ITEM_ACTIVITIES_HISTORY_V

1429: -- Bug 5223211 : start
1430: /*
1431: CURSOR CUR_NOTIFICATION IS
1432: SELECT NOTIFICATION_ID
1433: FROM WF_ITEM_ACTIVITIES_HISTORY_V
1434: WHERE ITEM_KEY = p_itemkey
1435: AND ITEM_TYPE = p_itemtype
1436: AND ACTIVITY_TYPE = 'NOTICE'
1437: AND NOTIFICATION_STATUS = 'OPEN'

Line 1981: from WF_ITEM_ACTIVITIES_HISTORY_V

1977: p_item_key out NOCOPY varchar2,
1978: p_item_type out NOCOPY varchar2) is
1979: cursor getItemKey is
1980: select ITEM_KEY, ITEM_TYPE
1981: from WF_ITEM_ACTIVITIES_HISTORY_V
1982: where NOTIFICATION_ID = p_notif;
1983: BEGIN
1984: open getItemKey;
1985: fetch getItemKey into p_item_key,p_item_type;