Oracle Hierarchy to Get All Children and All Parents of Each ID Using Recursive CTE

Recursive Queries with 2 Variables and Select on Status