oracle "with as" subquery

with_as.sql

WITH typelist AS
     (SELECT 0 AS n
        FROM DUAL
       WHERE 1 = 0
      UNION
      SELECT 1 AS n
        FROM DUAL
      UNION
      SELECT 2 AS n
        FROM DUAL)
SELECT *
  FROM personnel_type t
 WHERE t.personnel_type_id NOT IN (SELECT n
                                     FROM typelist);