The threat of strike action at one of Scottish & Newcastle's UK brewery has been averted.