DBA Data[Home] [Help]

APPS.WF_REPOPULATE_AQ dependencies on WF_NOTIFICATIONS

Line 26: from WF_ITEM_ACTIVITY_STATUSES IAS, WF_NOTIFICATIONS N

22: PRAGMA AUTONOMOUS_TRANSACTION;
23:
24: Cursor CN IS
25: Select N.NOTIFICATION_ID
26: from WF_ITEM_ACTIVITY_STATUSES IAS, WF_NOTIFICATIONS N
27: where IAS.Item_Type = x_Item_Type
28: and IAS.Item_Key = x_Item_Key
29: and IAS.NOTIFICATION_ID = N.GROUP_ID
30: and N.status = 'OPEN'