APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_USERS

Line 190: FROM wf_users wfu

186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action
187: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */
188: CURSOR c_responderid(p_responder VARCHAR2) IS
189: SELECT nvl((wfu.orig_system_id), -9996)
190: FROM wf_users wfu
191: WHERE wfu.name = p_responder
192: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
193:
194: BEGIN

Line 262: its orig_system_id from wf_users. If no matched rows found from

258: FROM wf_notifications wfn
259: WHERE wfn.notification_id = x_notification_id;
260:
261: /* csheu bug #1287135 use reponder value in wf_notification to find
262: its orig_system_id from wf_users. If no matched rows found from
263: wf_users then we will use l_recipient_role value from wf_notification
264: to find its orig_system_id from wf_users instead.
265: */
266:

Line 263: wf_users then we will use l_recipient_role value from wf_notification

259: WHERE wfn.notification_id = x_notification_id;
260:
261: /* csheu bug #1287135 use reponder value in wf_notification to find
262: its orig_system_id from wf_users. If no matched rows found from
263: wf_users then we will use l_recipient_role value from wf_notification
264: to find its orig_system_id from wf_users instead.
265: */
266:
267: OPEN c_responderid(l_responder);

Line 264: to find its orig_system_id from wf_users instead.

260:
261: /* csheu bug #1287135 use reponder value in wf_notification to find
262: its orig_system_id from wf_users. If no matched rows found from
263: wf_users then we will use l_recipient_role value from wf_notification
264: to find its orig_system_id from wf_users instead.
265: */
266:
267: OPEN c_responderid(l_responder);
268: FETCH c_responderid INTO x_responder_id;