DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on WF_NOTIFICATIONS

Line 2878: select notification_id from wf_notifications

2874: and xrh.status not in ('SUCCESSFUL','SUCCESSFUL WITH WARNINGS','OPEN','CANCELLED')
2875: and wi.status_code in ('INERROR_CHECK_NOTIFY');
2876:
2877: cursor c_notification(p_context varchar2) is
2878: select notification_id from wf_notifications
2879: where message_type='IEXSTFFM'
2880: and MESSAGE_NAME='SEND FAILER MESSAGE'
2881: and status='OPEN'
2882: AND context like p_context; -- 'IEXSTFFM:14515%' ;