1998 Oldsmobile Aurora

I don't really know what you mean by "no voltage back to module from sensor". Do you mean you checked for voltage at your camshaft sensor? And what "Module" are you referring to?

Your camshaft sensor produces its own voltage, but the engine has to be turning in order for it to do that.

Start your engine (with all sensors and connectors in place), then probe the back of the camshaft sensor with a voltage meter. Put one lead in one wire, and the other lead in the other.

If you can't get the leads into the backs of the sensors connector, then take two very thin stick pins and insert them into the wiring all the way. Use alligator clamps at the ends of your meter's leads and clamp them to the pins. This'll give you your reading.

You should see a voltage reading. Who much will depend on the specs for your motor. Go to AutoZone and ask them to look them up. (I don't currently have access to that information)

If it's out of spec, replace it.

Another option:
Remove it and locate a parts store that's equipped to check it. If you can't find one, call around to some mechanics. They shouldn't charge you much to check it off the vehicle.