SELECT empno ID, mgr pid,
       CASE
          WHEN empno = :p235_empno
             THEN    '<span class="t1000url">'
                  || ename
                  || '   >>'
                  || '</span>'
          ELSE ename
       END NAME,
       'f?p=&APP_ID.:235:&SESSION.::NO::P235_EMPNO:' 
       || empno LINK, NULL a1,
       NULL a2
  FROM emp