APPS.EGO_SECURITY_PUB dependencies on FND_MENUS

Line 97: fnd_menus menus

93: cp_end_date DATE) IS
94: -- Bug 16182516 Changing sql as this is same sql as on in grant_role_guid API, Call to this API will result in improved performance.
95: SELECT 'X'
96: FROM fnd_objects obj,
97: fnd_menus menus
98: WHERE obj.obj_name= cp_object_name
99: AND menus.menu_name=cp_menu_name
100: and exists
101: ( SELECT /*+ no_unnest */ 'x'

Line 333: fnd_menus menus

329:
330: -- Bug 16182516 Changing sql as this is same sql as on in grant_role_guid API, Call to this API will result in improved performance.
331: SELECT 'X'
332: FROM fnd_objects obj,
333: fnd_menus menus
334: WHERE obj.obj_name= cp_object_name
335: AND menus.menu_name=cp_menu_name
336: and exists
337: ( SELECT /*+ no_unnest */ 'x'

Line 1645: FROM fnd_menus

1641: l_role_id NUMBER;
1642:
1643: CURSOR get_role_id(cp_role_name VARCHAR2) IS
1644: SELECT menu_id
1645: FROM fnd_menus
1646: WHERE menu_name =cp_role_name;
1647:
1648: CURSOR check_for_duplicate (cp_grantee_key VARCHAR2,
1649: cp_grantee_type VARCHAR2,

Line 1665: fnd_menus menus

1661:
1662: -- Bug 16182516 Adding here also as sql is same and call to this API in a flow will improve performance
1663: SELECT 'X'
1664: FROM fnd_objects obj,
1665: fnd_menus menus
1666: WHERE obj.obj_name= cp_object_name
1667: AND menus.menu_name=cp_menu_name
1668: and exists
1669: ( SELECT /*+ no_unnest */ 'x'