> the 2nd affair with a subordinate is basically always a firing offense under the sexual harassment and/or code of conduct policy, whether you are a CEO or not.

In my company, it's explicitly not forbidden, but the relationship has to be disclosed to HR early on (source: yearly training). That being said, I'm not sure what HR is going to do with the information.