Line 978: CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID = (SELECT MENU_ID FROM FND_MENUS
974: WHERE MEV.MENU_ID IN (
975: SELECT SUB_MENU_ID
976: FROM FND_MENU_ENTRIES
977: WHERE SUB_MENU_ID IS NOT NULL 978: CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID = (SELECT MENU_ID FROM FND_MENUS 979: WHERE MENU_NAME=p_menu_name)
980: )
981: AND MEV.FUNCTION_ID = FF.FUNCTION_ID
982: AND BIS_PMV_UTIL.getParameterValue(FF.PARAMETERS, 'pRequestType') = 'P';