The Last Shot (2004)

This is a black comedy and it is entertaining.There is a scene where Emily French pees into the glass in the middle of a high class restaurant.It is priceless :)

http://www.imdb.com/title/tt0357054/