Re Daniel E’s post and responses below
I’m finding the use of the subjunctive past for future actions unexpectedly tricky, I think because the English "I need to leave by nine" or "they need us to arrive", already includes the idea of a completed future action (you can’t leave without having left or arrive without having arrived!)
Is the subjunctive present ever an option in this type of sentence or is the subjunctive past mandated?