DBA Data[Home] [Help]

APPS.PO_DIFF_SUMMARY_PKG dependencies on WF_NOTIFICATIONS

Line 3448: l_nid wf_notifications.notification_id%TYPE;

3444: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3445: d_position NUMBER;
3446:
3447:
3448: l_nid wf_notifications.notification_id%TYPE;
3449: l_session_user_id fnd_user.USER_ID%TYPE;
3450: l_responder_id fnd_user.USER_ID%TYPE;
3451: l_responder_name fnd_user.user_name%TYPE;
3452:

Line 3476: wf_notifications wfn

3472:
3473: SELECT fu.USER_ID, fu.user_name
3474: INTO l_responder_id, l_responder_name
3475: FROM fnd_user fu,
3476: wf_notifications wfn
3477: WHERE wfn.notification_id = l_nid
3478: AND wfn.original_recipient = fu.user_name;
3479:
3480: d_position := 2;