DBA Data[Home] [Help]

APPS.PSP_WF_EFF_PKG dependencies on WF_NOTIFICATIONS

Line 621: FROM wf_notifications

617: l_responder_display_name VARCHAR2(240);
618:
619: CURSOR get_approval_responder_csr IS
620: SELECT responder
621: FROM wf_notifications
622: WHERE notification_id =
623: --(SELECT MAX(notification_id) Commented for bug fix 3263333
624: (SELECT notification_id -- Introduced for bug fix 3263333
625: FROM wf_item_activity_statuses -- Changed to base table for bug fix 3263333

Line 667: FROM wf_notifications

663: l_responder_display_name VARCHAR2(240);
664:
665: CURSOR get_cert_responder_csr IS
666: SELECT responder
667: FROM wf_notifications
668: WHERE notification_id =
669: --(SELECT MAX(notification_id) Commented for bug fix 3263333
670: (SELECT notification_id -- Introduced for bug fix 3263333
671: FROM wf_item_activity_statuses -- changed to base table for bug fix 3263333