Plans by Pendle Council to spend £2milion on a new waste transfer site have been torn-up by councillors in setting the new budget.