Actually, it doesn't, but it's a nice myth.
If one has the affair while maintaining a security clearance it puts you at risk for blackmail. You think you know something about clearances and I can guarantee you it does indeed....just as being an active alcoholic does and having money problems does...