Query SQL:
SELECT A.EMPLID, B.EMPLID, C.NAME_DISPLAY, D.NAME_DISPLAY, 'XXX-XX-' || substr ( A.NATIONAL_ID, 6, 4), 'XXX-XX-' || substr ( B.NATIONAL_ID, 6, 4)
FROM PS_SCC_PERS_NI_QVW A, PS_SCC_PERS_NI_QVW B, PS_CU_BIO_VW C, PS_CU_BIO_VW D
WHERE A.EMPLID <> B.EMPLID
AND A.COUNTRY = B.COUNTRY
AND A.NATIONAL_ID_TYPE = B.NATIONAL_ID_TYPE
AND A.NATIONAL_ID = B.NATIONAL_ID
AND A.EMPLID < B.EMPLID
AND A.NATIONAL_ID <> 'XXXXXXXXX'
AND A.EMPLID = C.EMPLID
AND B.EMPLID = D.EMPLID
ORDER BY 1