Code P0340

My car made a pop noise and died on me. I can get spark from first coil plug, but not the second one. I checked for a code and p0340 came up for camshaft sensor. Replaced with a new one and still cannot get a spark from second coil plug.

Where exactly does the wiring harness for the camshaft sensor leads/plugs into? I am thinking something is grounded/shorted that is no't suppose to be but hard to tell with all the wires leading everywhere.