WITH RECURSIVE CTE AS ( SELECT DEPT_ID, DEPT_NAME, UP_DEPT_ID, DEPT_LOC, DEPT_SORT_ORDR, DEPT_STATUS, DEPT_DEPTH, TOP_DEPT_YN, 1 AS LEVEL FROM ORG_DEPARTMENT UNION ALL SELECT A.DEPT_ID, A.DEPT_NAME, A.UP_DEPT_ID, A.DEPT_LOC, A.DEPT_SORT_ORDR, A.DEPT_STATUS, A.DEPT_DEPTH, A.TOP_DEPT_YN, 1 + B.LEVEL AS LEVEL FROM ORG_DEPARTMENT A INNER JOIN CTE B ON A.UP_DEPT_ID = B.DEPT_ID ) SELECT DISTINCT FUNC_..