Sex scandal costs another law enforcement officer his job