SELECT emp_id
  FROM (SELECT emp_id, emp_family_cd
             , RANK() OVER(PARTITION BY emp_id ORDER BY emp_family_cd) rn
             , COUNT(*) OVER(PARTITION BY emp_id) cnt
          FROM emp_family_tbl
         WHERE emp_id <> :asEmp_id
        )
 WHERE (emp_family_cd, rn, cnt)
    IN (SELECT emp_family_cd
             , RANK() OVER(ORDER BY emp_family_cd) rn
             , COUNT(*) OVER() cnt
          FROM emp_family_tbl
         WHERE emp_id = :asEmp_id
        )
 GROUP BY emp_id, cnt
HAVING COUNT(*) = cnt