Recursive Queries with 2 Variables and Select on Status

How to Use Recursive SQL Queries in Oracle for Efficient Hierarchical Data Retrieval