DBA Data[Home] [Help]

APPS.EGO_SECURITY_PUB dependencies on FND_MENUS

Line 98: fnd_menus menus

94:
95: SELECT 'X'
96: FROM fnd_grants grants,
97: fnd_objects obj,
98: fnd_menus menus
99: WHERE grants.grantee_key=cp_grantee_key
100: AND grants.grantee_type=cp_grantee_type
101: AND grants.menu_id=menus.menu_id
102: AND menus.menu_name=cp_menu_name

Line 308: fnd_menus menus

304:
305: SELECT 'X'
306: FROM fnd_grants grants,
307: fnd_objects obj,
308: fnd_menus menus
309: WHERE grants.grantee_key=cp_grantee_key
310: AND grants.grantee_type=cp_grantee_type
311: AND grants.menu_id=menus.menu_id
312: AND menus.menu_name=cp_menu_name

Line 1590: FROM fnd_menus

1586: l_role_id NUMBER;
1587:
1588: CURSOR get_role_id(cp_role_name VARCHAR2) IS
1589: SELECT menu_id
1590: FROM fnd_menus
1591: WHERE menu_name =cp_role_name;
1592:
1593: CURSOR check_for_duplicate (cp_grantee_key VARCHAR2,
1594: cp_grantee_type VARCHAR2,

Line 1610: fnd_menus menus

1606:
1607: SELECT 'X'
1608: FROM fnd_grants grants,
1609: fnd_objects obj,
1610: fnd_menus menus
1611: WHERE grants.grantee_key=cp_grantee_key
1612: AND grants.grantee_type=cp_grantee_type
1613: AND grants.menu_id=menus.menu_id
1614: AND menus.menu_name=cp_menu_name