APPS.XDP_MESSAGE dependencies on WF_NOTIFICATIONS

Line 22: -- FROM wf_notifications wf

18:
19: /* Corrected the following SQL to fix bug 3957604. dputhiye. 27/10/04 */
20: -- CURSOR c_notification_to_respond_to IS
21: -- SELECT wf.notification_id, msg.msg_id, msg.msg_code
22: -- FROM wf_notifications wf
23: -- , xnp_msgs msg
24: -- WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
25: -- AND wf.status = 'OPEN'
26: -- AND msg.msg_code like '||p_msg_to_retry||'

Line 33: FROM wf_notifications wf

29: -- SUBSTR(subject,INSTR(subject,' - ')+3,LENGTH(subject));
30:
31: CURSOR c_notification_to_respond_to IS
32: SELECT wf.notification_id, msg.msg_id, msg.msg_code
33: FROM wf_notifications wf
34: , xnp_msgs msg
35: WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
36: AND wf.status = 'OPEN'
37: AND msg.msg_code like p_msg_to_retry