DBA Data[Home] [Help]

APPS.PO_SECURITY_CHECK_SV dependencies on WF_USERS

Line 244: FROM wf_users wfu

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

Line 279: l_original_recipient_id wf_users.orig_system_id%type;

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

Line 280: l_recipient_id wf_users.orig_system_id%type;

276:
277: l_notification_id WF_NOTIFICATIONS.notification_id%type;
278: l_responder WF_NOTIFICATIONS.responder%type;
279: l_original_recipient_id wf_users.orig_system_id%type;
280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
283:
284: l_from_role WF_NOTIFICATIONS.from_role%TYPE; --Bug 12534279