APPS.AMW_SECURITY_PUB dependencies on FND_COMPILED_MENU_FUNCTIONS

Line 1003: from fnd_compiled_menu_functions cmf

999: AND g.object_id = cp_object_id
1000: AND ( (cp_function_id = -1)
1001: OR (g.menu_id in
1002: (select cmf.menu_id
1003: from fnd_compiled_menu_functions cmf
1004: where cmf.function_id = cp_function_id)))
1005: AND ( g.ctx_secgrp_id = -1
1006: OR g.ctx_secgrp_id =
1007: SYS_CONTEXT('FND','SECURITY_GROUP_ID'))

Line 1055: from fnd_compiled_menu_functions cmf

1051: and g.object_id = cp_object_id
1052: and ((cp_function_id = -1)
1053: or (g.menu_id in
1054: (select cmf.menu_id
1055: from fnd_compiled_menu_functions cmf
1056: where cmf.function_id = cp_function_id)))
1057: and ( g.ctx_secgrp_id = -1
1058: or g.ctx_secgrp_id =
1059: SYS_CONTEXT('FND','SECURITY_GROUP_ID'))

Line 1105: from fnd_compiled_menu_functions cmf

1101: AND g.instance_type = 'SET'
1102: AND g.object_id = cp_object_id
1103: AND (g.menu_id in
1104: (select cmf.menu_id
1105: from fnd_compiled_menu_functions cmf
1106: where cmf.function_id = cp_function_id))
1107: AND g.instance_set_id = instance_sets.instance_set_id
1108: AND ( g.ctx_secgrp_id = -1
1109: OR g.ctx_secgrp_id =

Line 1152: from fnd_compiled_menu_functions cmf

1148: WHERE g.grantee_key = u2.role_name
1149: AND g.object_id = cp_object_id
1150: AND (g.menu_id in
1151: (select cmf.menu_id
1152: from fnd_compiled_menu_functions cmf
1153: where cmf.function_id = cp_function_id))
1154: AND g.instance_set_id = instance_sets.instance_set_id
1155: AND ( g.ctx_secgrp_id = -1
1156: OR g.ctx_secgrp_id =

Line 1185: from fnd_compiled_menu_functions cmf

1181: AND (g.grantee_type = 'GLOBAL')
1182: AND g.object_id = cp_object_id
1183: AND (g.menu_id in
1184: (select cmf.menu_id
1185: from fnd_compiled_menu_functions cmf
1186: where cmf.function_id = cp_function_id))
1187: AND g.instance_set_id = instance_sets.instance_set_id
1188: AND ( g.ctx_secgrp_id = -1
1189: OR g.ctx_secgrp_id =

Line 1270: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

1266: return;
1267: end if;
1268:
1269:
1270: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
1271: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
1272: FND_FUNCTION.FAST_COMPILE;
1273: end if;
1274:

Line 1688: ' FROM fnd_grants g, fnd_compiled_menu_functions cmf ' ||

1684: /* against the grants table */
1685: -- abedajna begin
1686:
1687: top := ' SELECT g.grant_guid ' ||
1688: ' FROM fnd_grants g, fnd_compiled_menu_functions cmf ' ||
1689: ' WHERE g.instance_type = '||''''||'SET'||'''' ||
1690: ' and g.instance_set_id = ' || d_instance_set_id ||
1691: ' AND g.menu_id = cmf.menu_id AND cmf.function_id = '|| l_function_id;
1692:

Line 1872: ' from fnd_compiled_menu_functions cmf'||

1868: if (l_function_id <> -1) then
1869: l_instance_predicate := l_instance_predicate ||
1870: ' AND GNT.menu_id in'||
1871: ' (select cmf.menu_id'||
1872: ' from fnd_compiled_menu_functions cmf'||
1873: ' where cmf.function_id = :FUNCTION_ID_BIND )';
1874: x_function_id := l_function_id;
1875: if(x_bind_order is not NULL) then
1876: x_bind_order := x_bind_order || 'F';

Line 1886: ' from fnd_compiled_menu_functions cmf'||

1882: if (l_function_id <> -1) then
1883: l_instance_predicate := l_instance_predicate ||
1884: ' AND GNT.menu_id in'||
1885: ' (select cmf.menu_id'||
1886: ' from fnd_compiled_menu_functions cmf'||
1887: ' where cmf.function_id = '||l_function_id||')';
1888: end if;
1889: end if;
1890: l_instance_predicate := l_instance_predicate ||