DBA Data[Home] [Help]

APPS.WF_DIRECTORY dependencies on WF_USER_ROLE_ASSIGNMENTS_V

Line 4953: or exists (select null from wf_user_role_assignments_v

4949: where name=p_rolename)
4950: and ( exists (select null from wf_user_roles
4951: where role_name=p_rolename
4952: )
4953: or exists (select null from wf_user_role_assignments_v
4954: where role_name=p_rolename
4955: )
4956: or exists (select null from wf_role_hierarchies
4957: where (super_name=p_rolename

Line 5001: or exists (select null from wf_user_role_assignments_v

4997: where name=p_username)
4998: and ( exists (select null from wf_user_roles
4999: where user_name=p_username
5000: )
5001: or exists (select null from wf_user_role_assignments_v
5002: where user_name=p_username
5003: ));
5004:
5005: --if we have reached here, it implies that the user

Line 5046: or exists (select null from wf_user_role_assignments_v

5042: and ( exists (select null from wf_user_roles
5043: where role_name=p_rolename
5044: and user_name=p_username
5045: )
5046: or exists (select null from wf_user_role_assignments_v
5047: where role_name=p_rolename
5048: and user_name=p_username
5049: )
5050: or exists (select null from wf_role_hierarchies