APPS.PO_SECURITY_CHECK_SV dependencies on WF_USERS

Line 243: FROM wf_users wfu

239: WIAS.NOTIFICATION_ID = WF.group_id;
240:
241: CURSOR c_responderid(p_responder VARCHAR2) IS
242: SELECT nvl((wfu.orig_system_id), -9996)
243: FROM wf_users wfu
244: WHERE wfu.name = p_responder
245: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
246:
247: -- Bug 4633202: Cursor to get list of all granters who has provided worklist

Line 278: l_original_recipient_id wf_users.orig_system_id%type;

274:
275:
276: l_notification_id WF_NOTIFICATIONS.notification_id%type;
277: l_responder WF_NOTIFICATIONS.responder%type;
278: l_original_recipient_id wf_users.orig_system_id%type;
279: l_recipient_id wf_users.orig_system_id%type;
280: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
281: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
282:

Line 279: l_recipient_id wf_users.orig_system_id%type;

275:
276: l_notification_id WF_NOTIFICATIONS.notification_id%type;
277: l_responder WF_NOTIFICATIONS.responder%type;
278: l_original_recipient_id wf_users.orig_system_id%type;
279: l_recipient_id wf_users.orig_system_id%type;
280: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
281: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
282:
283: Begin