DBA Data[Home] [Help]

APPS.CS_MESSAGES_PKG dependencies on WF_NOTIFICATIONS

Line 43: FROM wf_notifications ntf

39: FROM dual;
40:
41: CURSOR l_ntf_csr IS
42: SELECT ntf.notification_id
43: FROM wf_notifications ntf
44: WHERE ntf.group_id = l_ntf_group_id;
45:
46: CURSOR l_priority_csr IS
47: SELECT meaning

Line 315: FROM wf_notifications ntf, wf_roles wf, cs_messages msg

311: wf.display_name responder,
312: msg.confirmation,
313: msg.notification_id,
314: msg.sender_role sender
315: FROM wf_notifications ntf, wf_roles wf, cs_messages msg
316: WHERE msg.message_id = l_message_id
317: AND msg.notification_id = ntf.notification_id
318: AND ntf.responder = wf.name(+)
319: FOR UPDATE OF msg.message_id;