APPS.WF_XML dependencies on WF_USER_ROLES

Line 147: from wf_user_roles

143: select name
144: from wf_users
145: where (name, orig_system, orig_system_id) in
146: (select user_name, user_orig_system, user_orig_system_id
147: from wf_user_roles
148: where role_name = urc1.role
149: and role_orig_system = substr(urc1.role, 1, urc1.colon-1)
150: and role_orig_system_id = substr(urc1.role, urc1.colon+1)
151: and user_name <> role_name

Line 163: from wf_user_roles

159: select name
160: from wf_users
161: where (name, orig_system, orig_system_id) in
162: (select user_name, user_orig_system, user_orig_system_id
163: from wf_user_roles
164: where role_name = urc2.role
165: and user_name <> role_name)
166: and notification_preference not in ('SUMMARY','QUERY')
167: order by notification_preference, language;

Line 2928: from WF_USER_ROLES UR

2924: orig_system_id number;
2925:
2926: cursor members(rname varchar2, rorig varchar2, rorigid number) is
2927: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
2928: from WF_USER_ROLES UR
2929: where UR.ROLE_NAME = rname
2930: and UR.ROLE_ORIG_SYSTEM = rorig
2931: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
2932: and ((UR.USER_NAME <> UR.ROLE_NAME) or

Line 4083: from WF_USER_ROLES UR

4079: is
4080:
4081: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4082: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
4083: from WF_USER_ROLES UR
4084: where UR.ROLE_NAME = rname
4085: and UR.ROLE_ORIG_SYSTEM = rorig
4086: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
4087: and ((UR.USER_NAME <> UR.ROLE_NAME) or

Line 4847: from WF_USER_ROLES UR

4843: is
4844:
4845: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4846: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID
4847: from WF_USER_ROLES UR
4848: where UR.ROLE_NAME = rname
4849: and UR.ROLE_ORIG_SYSTEM = rorig
4850: and UR.ROLE_ORIG_SYSTEM_ID = rorigid
4851: and ((UR.USER_NAME <> UR.ROLE_NAME) or