seq_fn_user
seq_fn_role
seq_fn_menu
seq_fn_menu
seq_fn_broadcast_message
select distinct functionCd from MenuData
from MenuData where menuSetCode = :menu_set_cd and parentMenu is null
FROM UrlsAccessible A where upper(A.urlsAccessibleKey.url) = upper(:current_url)
select firstName, lastName from User where id = :user_id
select email from User where id = :user_id
select id, firstName, lastName from User where active = true order by lastName, firstName
select name from Role where id = :role_id
select id, name from Role order by name
from CommonWidget where category = :cat order by sortOrder, title