APPS.WF_XML dependencies on WF_USER_ROLES

Line 152: from wf_user_roles

148: select name
149: from wf_users
150: where (name, orig_system, orig_system_id) in
151: (select user_name, user_orig_system, user_orig_system_id
152: from wf_user_roles
153: where role_name = urc1.role
154: and role_orig_system = substr(urc1.role, 1, urc1.colon-1)
155: and role_orig_system_id = substr(urc1.role, urc1.colon+1)
156: and user_name <> role_name

Line 168: from wf_user_roles

164: select name
165: from wf_users
166: where (name, orig_system, orig_system_id) in
167: (select user_name, user_orig_system, user_orig_system_id
168: from wf_user_roles
169: where role_name = urc2.role
170: and user_name <> role_name)
171: and notification_preference not in ('SUMMARY','QUERY')
172: order by notification_preference, language;

Line 2872: from WF_USER_ROLES UR

2868: orig_system_id number;
2869:
2870: cursor members(rname varchar2, rorig varchar2, rorigid number) is
2871: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
2872: from WF_USER_ROLES UR
2873: where UR.ROLE_NAME = rname
2874: and UR.ROLE_ORIG_SYSTEM = rorig
2875: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
2876: and ((UR.USER_NAME <> UR.ROLE_NAME) or

Line 4099: from WF_USER_ROLES UR

4095: is
4096:
4097: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4098: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
4099: from WF_USER_ROLES UR
4100: where UR.ROLE_NAME = rname
4101: and UR.ROLE_ORIG_SYSTEM = rorig
4102: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
4103: and ((UR.USER_NAME <> UR.ROLE_NAME) or

Line 4757: from WF_USER_ROLES UR

4753: is
4754:
4755: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4756: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
4757: from WF_USER_ROLES UR
4758: where UR.ROLE_NAME = rname
4759: and UR.ROLE_ORIG_SYSTEM = rorig
4760: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
4761: and ((UR.USER_NAME <> UR.ROLE_NAME) or

Line 5751: FROM wf_user_roles wu, wf_roles wr

5747: -- returns the users having the notification preference of
5748: -- 'SUMMARY' or 'SUMHTML' for the given role
5749: CURSOR c_get_sum_users(p_roleName VARCHAR2) is
5750: SELECT user_name
5751: FROM wf_user_roles wu, wf_roles wr
5752: WHERE wu.role_name = p_roleName
5753: AND wr.name = wu.user_name
5754: AND wu.user_orig_system = wr.orig_system
5755: AND wu.user_orig_system_id = wr.orig_system_id