APPS.AMW_SECURITY_PUB dependencies on WF_LOCAL_ROLES

Line 1040: from wf_local_roles incr1, fnd_user u1

1036: (
1037: select cp_user_name name from dual
1038: union all
1039: select incr1.name name
1040: from wf_local_roles incr1, fnd_user u1
1041: where 'HZ_PARTY' = incr1.orig_system
1042: and u1.user_name = cp_user_name
1043: and u1.person_party_id = incr1.orig_system_id
1044: and incr1.partition_id = 9 /* HZ_PARTY */

Line 1090: from wf_local_roles incr1, fnd_user u1

1086: (
1087: select cp_user_name name from dual
1088: union all
1089: select incr1.name name
1090: from wf_local_roles incr1, fnd_user u1
1091: where 'HZ_PARTY' = incr1.orig_system
1092: and u1.user_name = cp_user_name
1093: and u1.person_party_id = incr1.orig_system_id
1094: and incr1.partition_id = 9 /* HZ_PARTY */

Line 1138: from wf_local_roles incr1, fnd_user u1

1134: (
1135: select cp_user_name name from dual
1136: union all
1137: select incr1.name name
1138: from wf_local_roles incr1, fnd_user u1
1139: where 'HZ_PARTY' = incr1.orig_system
1140: and u1.user_name = cp_user_name
1141: and u1.person_party_id = incr1.orig_system_id
1142: and incr1.partition_id = 9 /* HZ_PARTY */

Line 1700: ' from wf_local_roles src, ' ||

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 ' ||
1702: ' where src.name = '||''''||l_user_name||'''' ||
1703: ' and src.parent_orig_system = incrns.parent_orig_system ' ||
1704: ' and src.parent_orig_system_id = incrns.parent_orig_system_id) ' ||

Line 1701: ' wf_local_roles incrns ' ||

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 ' ||
1702: ' where src.name = '||''''||l_user_name||'''' ||
1703: ' and src.parent_orig_system = incrns.parent_orig_system ' ||
1704: ' and src.parent_orig_system_id = incrns.parent_orig_system_id) ' ||
1705: ' )) ' ||

Line 1714: ' from wf_local_roles src ' ||

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 ' ||
1716: ' where src.name = '||''''||l_user_name||'''' ||
1717: ' and src.parent_orig_system = ' ||
1718: ' incrns.parent_orig_system ' ||

Line 1715: ' ,wf_local_roles incrns ' ||

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 ' ||
1716: ' where src.name = '||''''||l_user_name||'''' ||
1717: ' and src.parent_orig_system = ' ||
1718: ' incrns.parent_orig_system ' ||
1719: ' and src.parent_orig_system_id = ' ||

Line 1845: ' from wf_local_roles src '||

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 '||
1847: ' where src.name = ' ||
1848: l_user_name_bind ||
1849: ' and src.parent_orig_system '||

Line 1846: ' ,wf_local_roles incrns '||

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 '||
1847: ' where src.name = ' ||
1848: l_user_name_bind ||
1849: ' and src.parent_orig_system '||
1850: ' = incrns.parent_orig_system '||