With a correlated subquery, the EXISTS clause is evaluated separately for each row of the table referenced in outer query,
SELECT PK_EMP_CODE FROM MSTEMPLOYEE MS
WHERE EXISTS(
SELECT FK_EMP_ID FROM SANCTIONDETAILS SA WHERE SA.FK_SANC_EMPID='UTL001'
AND MS.PK_EMP_CODE=SA.FK_EMP_ID
)