APPS.AMW_SECURITY_PUB dependencies on DUAL

Line 993: dual

989: cp_object_id VARCHAR2,
990: cp_instance_type VARCHAR2)
991: IS
992: select 1 from
993: dual
994: where exists
995: (
996: SELECT /*+ INDEX(g, FND_GRANTS_N1) */ 1
997: FROM fnd_grants g

Line 1029: dual

1025: cp_object_id VARCHAR2,
1026: cp_instance_type VARCHAR2)
1027: IS
1028: select 1 from
1029: dual
1030: where exists
1031: (
1032: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
1033: FROM

Line 1037: select cp_user_name name from dual

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
1040: from wf_local_roles incr1, fnd_user u1
1041: where 'HZ_PARTY' = incr1.orig_system

Line 1082: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual

1078: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
1079: instance_sets.predicate, instance_sets.instance_set_id,
1080: g.grant_guid
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: (

Line 1087: select cp_user_name 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
1090: from wf_local_roles incr1, fnd_user u1
1091: where 'HZ_PARTY' = incr1.orig_system

Line 1135: select cp_user_name name from dual

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
1138: from wf_local_roles incr1, fnd_user u1
1139: where 'HZ_PARTY' = incr1.orig_system