"Old Archers Die Hard" from Green Arrow vol.3 #1 (DC, 2004) by Kevin Smith, Phil Hester and Ande Parks
As it turns out, the Green Arrow resurrected by Hal Jordan was only a VERSION of Oliver Queen, leaving Oli's soul up in heaven no problem. This recreated GA had no soul and no memory of anything Longbow Hunters on. It's Kevin Smith's armchair theology, don't worry about it. His soul eventually returns to keep a bad guy from possessing it. Smith didn't stay for long, but did introduce a new female Speedy before he left the book to Brian Meltzer, and then to Judd Winick who gave Speedy HIV. I'm reading all of this off of Wikipedia, because past Smith and Hester, no one involved with the book really turned my crank.