APPS.AMW_SECURITY_PUB dependencies on WF_USER_ROLES

Line 231: from wf_user_roles

227: end if;
228:
229: select 1
230: into l_dummy
231: from wf_user_roles
232: where user_name = p_user_name
233: and rownum = 1;
234:
235: g_ck_user_role_result := 'T';

Line 1035: from wf_user_roles wur,

1031: (
1032: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
1033: FROM
1034: ( select /*+ NO_MERGE */ role_name
1035: from wf_user_roles wur,
1036: (
1037: select cp_user_name name from dual
1038: union all
1039: select incr1.name name

Line 1085: from wf_user_roles wur,

1081: FROM
1082: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
1083: union all
1084: select role_name
1085: from wf_user_roles wur,
1086: (
1087: select cp_user_name name from dual
1088: union all
1089: select incr1.name name

Line 1133: from wf_user_roles wur,

1129: instance_sets.predicate, instance_sets.instance_set_id,
1130: g.grant_guid
1131: FROM
1132: ( select /*+ NO_MERGE */ role_name
1133: from wf_user_roles wur,
1134: (
1135: select cp_user_name name from dual
1136: union all
1137: select incr1.name name

Line 1383: -- a group in WF_USER_ROLES then we could go down to only 3 SQL

1379: -- We had originally tried to check all these possibilities with
1380: -- a single statement, but it didn't perform adequately due to
1381: -- the ORs and sorting necessary, so this is the best solution.
1382: -- Perhaps if we get the WF folks to put GLOBAL (all) users into the
1383: -- a group in WF_USER_ROLES then we could go down to only 3 SQL
1384: -- or even one.
1385:
1386: --
1387: -- Do not check for GLOBAL grants when the user is GUEST

Line 1697: ' from wf_user_roles ' ||

1693:
1694:
1695: mid1 := ' AND ((g.grantee_key in ' ||
1696: ' (select role_name ' ||
1697: ' from wf_user_roles ' ||
1698: ' where user_name in ' ||
1699: ' (select incrns.name ' ||
1700: ' from wf_local_roles src, ' ||
1701: ' wf_local_roles incrns ' ||

Line 1711: ' from wf_user_roles ' ||

1707:
1708:
1709: mid2 := ' AND (g.grantee_key in ' ||
1710: ' (select role_name ' ||
1711: ' from wf_user_roles ' ||
1712: ' where user_name in ' ||
1713: ' (select incrns.name ' ||
1714: ' from wf_local_roles src ' ||
1715: ' ,wf_local_roles incrns ' ||

Line 1842: ' from wf_user_roles wur'||

1838: l_instance_predicate :=
1839: l_instance_predicate ||
1840: ' ( GNT.grantee_key in ' ||
1841: ' (select role_name '||
1842: ' from wf_user_roles wur'||
1843: ' where wur.user_name in '||
1844: ' (select incrns.name '||
1845: ' from wf_local_roles src '||
1846: ' ,wf_local_roles incrns '||