280: (INTERNAL_ROLE_ID,INTERNAL_ROLE_NAME,DISPLAY_ROLE_NAME)
281: SELECT DISTINCT role_tl.menu_id internal_role_id,
282: role.menu_name internal_role_name,
283: role_tl.user_menu_name display_role_name
284: FROM fnd_menus_tl role_tl,
285: fnd_menus role,
286: fnd_menu_entries role_privs,
287: fnd_form_functions privs
288: WHERE privs.object_id = G_FND_OBJECT_ID
281: SELECT DISTINCT role_tl.menu_id internal_role_id,
282: role.menu_name internal_role_name,
283: role_tl.user_menu_name display_role_name
284: FROM fnd_menus_tl role_tl,
285: fnd_menus role,
286: fnd_menu_entries role_privs,
287: fnd_form_functions privs
288: WHERE privs.object_id = G_FND_OBJECT_ID
289: AND privs.function_id = role_privs.function_id