This situation has to be similar to someone stepping in dog poo every day, and coming in the office with it on their shoe.
But, if this is a mortgage office, as I assume it is, many of the "employees" are actually independent contractors. They are not held by the same standard that Boeing holds their employees to.
As long as this individual is producing income for the business owner, I doubt he would ever lose his position. Face it, if you are making ME $50k a year as an independent sales rep, you can sleep at your desk all you want. What the heck, maybe your wife is a b$%^* and you can't stand to be at home. You go out with clients, and buy drinks, a common occurance, what salesman hasn't. Remember, the wife is at home, with her constant nagging. So, you go to the office, only to be berated behind your back by a bunch of pansies who would starve to death if it wasn't for your sales ability, part of which, to them, looks like a "drinking problem".
Or, he may be a total alcoholic loser. If so, fire him immediately. Catch him when he smells like alcohol, get three witnesses, fire him. Simple.
I have seen it from all angles. When my stepdaughter was dying of Cancer, and my ex and I were breaking up at the same time, there were probably some days when I looked and smelled horrible to the folks in my office. Luckily, I was the top seller in the office. She died. The ex left. I am better. SERENITY NOW!!