DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on WF_NOTIFICATIONS

Line 3764: FROM wf_item_activity_statuses wfs, wf_notifications wfn

3760: -- Fix for Bug 7167583
3761: -- Cursor to retrieve the notification_id and the current user
3762: CURSOR get_notification_info IS
3763: SELECT wfn.notification_id, wfs.assigned_user
3764: FROM wf_item_activity_statuses wfs, wf_notifications wfn
3765: WHERE wfs.item_type = 'ARCMGTAP'
3766: AND wfs.item_key = p_itemkey
3767: AND wfs.notification_id is not null
3768: AND wfs.notification_id = wfn.notification_id