DBA Data[Home] [Help]

APPS.WF_DIRECTORY dependencies on WF_USER_ROLE_ASSIGNMENTS_V

Line 5090: or exists (select null from wf_user_role_assignments_v

5086: where name=p_rolename)
5087: and ( exists (select null from wf_user_roles
5088: where role_name=p_rolename
5089: )
5090: or exists (select null from wf_user_role_assignments_v
5091: where role_name=p_rolename
5092: )
5093: or exists (select null from wf_role_hierarchies
5094: where (super_name=p_rolename

Line 5138: or exists (select null from wf_user_role_assignments_v

5134: where name=p_username)
5135: and ( exists (select null from wf_user_roles
5136: where user_name=p_username
5137: )
5138: or exists (select null from wf_user_role_assignments_v
5139: where user_name=p_username
5140: ));
5141:
5142: --if we have reached here, it implies that the user

Line 5183: or exists (select null from wf_user_role_assignments_v

5179: and ( exists (select null from wf_user_roles
5180: where role_name=p_rolename
5181: and user_name=p_username
5182: )
5183: or exists (select null from wf_user_role_assignments_v
5184: where role_name=p_rolename
5185: and user_name=p_username
5186: )
5187: or exists (select null from wf_role_hierarchies