SQL & PL/SQL

Hi,

I am trying to create a query listing all menu's/ submenu's attached to a certain function.
I would like to use the "connect by" statement.
However i cannot get it right.
So far i have made the following query.

select distinct fnd_responsibility_vl.responsibility_name
,fnd_menus_vl.user_menu_name
,submenu.user_menu_name
,fnd_menus_vl.type
,fnd_menus_vl.menu_id
,fnd_menu_entries_vl.grant_flag
,fnd_form_functions_vl.function_name
,fnd_form_functions_vl.user_function_name
,fnd_user_resp_groups_direct.responsibility_id
from apps.fnd_form
,apps.fnd_user
,apps.fnd_menus_vl
,apps.fnd_menus_vl submenu
,apps.fnd_responsibility_vl
,apps.fnd_user_resp_groups_direct
,apps.fnd_form_functions_vl
,apps.fnd_menu_entries_vl
,apps.fnd_menu_entries_vl subm_entries
where fnd_form.application_id = fnd_responsibility_vl.application_id
and fnd_user_resp_groups_direct.responsibility_id = fnd_responsibility_vl.responsibility_id
and fnd_user_resp_groups_direct.responsibility_application_id = fnd_responsibility_vl.application_id
and fnd_user_resp_groups_direct.user_id = fnd_user.user_id
and fnd_form_functions_vl.application_id = fnd_form.application_id
and fnd_form_functions_vl.form_id = fnd_form.form_id
and fnd_menus_vl.menu_id = fnd_responsibility_vl.menu_id
and fnd_menus_vl.menu_id = fnd_menu_entries_vl.menu_id
and fnd_menus_vl.menu_id = subm_entries.menu_id (+)
and submenu.menu_id = subm_entries.sub_menu_id
and fnd_form_functions_vl.function_name ='AP_APXPAWKB'
and fnd_user.end_date is null
and fnd_responsibility_vl.end_date is null

START WITH
fnd_menu_entries_vl.menu_id
CONNECT BY
fnd_menu_entries_vl.menu_id = PRIOR fnd_menu_entries_vl.sub_menu_id

Anyone can help me out on this?