select "LEVEL_ID" as level_value 
       , "PAGE_NAME" as label_value 
       , 'f?p=&APP_ID.:'||"URL"||':&SESSION.' as target_value
       , null as is_current 
       , null as image_value 
       , null as image_attr_value 
       , null as image_alt_value 
       , "USER_DEFINED_ATTRIBUTE" as USER_DEFINED_ATTRIBUTE
from table (apex.access.get_emp_access(1))
start with "PARENT_MENU_ID" is null
connect by prior "PAGE_ID" = "PARENT_MENU_ID"

from table (apex.access.get_emp_access(HTMLDB_UTIL.get_current_user_id ()))

get_emp_access(1)

select HTMLDB_UTIL.get_current_user_id () from dual.

select * from table(apex.access.get_employee_id(HTMLDB_CUSTOM_AUTH.get_user));