Hello Gentlemen,
I went back to the same Nissan dealer, this time hauling a repair manual and the broken fuel pump with me, and I got much better information. (Getting the right person makes a difference.) They are recommending a Bosch fuel pump (part number 69616) for the L24(E) engine. I've ordered one from www.rockauto.com, and I'll let you if it works.
Thanks,
JoeyM