Seafarers at the Royal Fleet Auxiliary have voted to accept an improved pay offer, ending a long-running dispute.