It depends.
Imagine you're an accountant working for a general contractor. He wants to know why a client hasn't paid yet.
He told me that he will pay for the work once it's completed.
This sentence is perfectly acceptable if the work has yet to be completed.
He told me that he would pay for the work once it was completed.
This sentence i