DBA Data[Home] [Help]

APPS.PO_NOTIFICATIONS_SV3 dependencies on WF_USERS

Line 290: from wf_users

286: colon pls_integer;
287:
288: cursor c_role is
289: select orig_system_id
290: from wf_users
291: where name = x_role_name
292: and orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
293:
294: cursor corig_role is

Line 296: from wf_users

292: and orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
293:
294: cursor corig_role is
295: select orig_system_id
296: from wf_users
297: where orig_system = substr(x_role_name, 1, colon-1)
298: and orig_system_id = substr(x_role_name, colon+1)
299: and name = x_role_name
300: and orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');