A proposed ban on alcohol sponsorship will have a “detrimental effect” on Irish sport, an umbrella organisation has told an Oireachtas committee.