SELECT EMPLOYEE_ID AS ID
     , MANAGER_ID  AS PID
     , CASE
         WHEN EMPLOYEE_ID = :P4_EMPLOYEE_ID THEN
             '<span style="color:white;background-color:blue;">'||
             LAST_NAME||
             '</span>'
         ELSE
             LAST_NAME
       END AS NAME
     , 'f?p=&APP_ID.:4:'||:SESSION||'::NO::P4_EMPLOYEE_ID:'||EMPLOYEE_ID AS LINK
     , NULL        AS A1
     , NULL        AS A2
  FROM #OWNER#.EMPLOYEES

select case when connect_by_isleaf = 1 then 0
            when level = 1             then 1
            else                           -1
       end as status, 
       level, 
       label||': '||name as title, 
       case when item_type = 'P' then 'fa-file-text-o'
            when item_type = 'S' then 'fa-caret-square-o-right'
            when item_type = 'T' then 'fa-minus-square-o'
       else null
       end as icon, 
       id as value, 
       case when tooltip is not null then name||' - '||tooltip||'% complete'
            else name
       end as tooltip,
       case when item_type = 'P' then 
               apex_util.prepare_url('f?p='||:app_id||':7:'||:app_session||':T:::P3_SELECTED_NODE,P7_PROJ_ID:'||id||','||id)
            when item_type = 'T' then
               apex_util.prepare_url('f?p='||:app_id||':9:'||:app_session||':T:::P3_SELECTED_NODE,P9_PROJ_ID,P9_TASK_ID:'||id||','||link)
            when item_type = 'S' then 
               apex_util.prepare_url('f?p='||:app_id||':10:'||:app_session||':T:::P3_SELECTED_NODE,P10_PROJ_ID,P10_ROWID:'||id||','||link)
       end as link 
 from (
select 'P' item_type,
       t.label label,
       to_char(a.PROJ_ID) id,
       null parent,
       a.project_name name,
       a.status tooltip,
       null link
  from eba_demo_tree_projects a, (select wwv_flow_lang.system_message('PROJECT') label from dual) t
union all
select 'T' item_type,
       u.label label,
       to_char(b.proj_id)||'-'||to_char(b.task_id) id,
       to_char(b.proj_id) parent,
       b.task_name name,
       null tooltip,
       b.proj_id||','||b.task_id link
  from eba_demo_tree_task b, (select wwv_flow_lang.system_message('TASK') label from dual) u
union all
select 'S' item_type,
       v.label label,
       to_char(c.proj_id)||'-'||to_char(c.task_id)||'-'||to_char(c.sub_id) id,
       to_char(c.proj_id)||'-'||to_char(c.task_id) parent,
       c.sub_name name,
       null tooltip,
       c.proj_id||','||c.rowid link
  from eba_demo_tree_subtask c, (select wwv_flow_lang.system_message('SUBTASK') label from dual) v
)
start with parent is null
connect by prior id = parent
order siblings by name

select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
level,
ENAME as title
NULL as icon,
EMPNO as value,
ENAME as tooltip,
NULL as link
from EMP
start with MGR is null
connect by prior EMPNO = MGR
order siblings by ENAME

apex.jQuery("#my_tree").find("a:contains(#P81_CLASSIFIER_ID)").css("color","red");

select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
level,
ENAME as title
NULL as icon,
EMPNO as value,
ENAME as tooltip,
NULL as link
from EMP
start with MGR is null
connect by prior EMPNO = MGR
order siblings by ENAME

apex.jQuery("#my_tree").find("a:contains("+ $.trim($("#P81_CLASSIFIER_ID :selected").text()) + ")").css("color","red");