Menu->Responsibility

SELECT responsibility_name
FROM fnd_responsibility_vl
WHERE menu_id IN (SELECT menu_id
FROM fnd_menu_entries_vl
WHERE function_id IN (SELECT function_id
FROM fnd_menu_entries_vl
WHERE prompt = 'Define'))
UNION
SELECT responsibility_name
FROM fnd_responsibility_vl
WHERE menu_id IN (
SELECT menu_id
FROM fnd_menu_entries_vl
WHERE sub_menu_id IN (
SELECT menu_id
FROM fnd_menu_entries_vl
WHERE function_id IN (
SELECT function_id
FROM fnd_menu_entries_vl
WHERE prompt = 'Define')));