Thanks Andrew
I will try this and revert; I was specifying RECURSIVE for the second CTEas well.
Regards,Jitendra