query based on another query

Please advise if there is a better way to do this. I am new to Oracle and I am trying to create a new report. 1st query- I am trying to create a query that finds all inactive approvers in our system. 2nd query I need to requery the first query to see if any one else is on the same level as the person who is inactive.

Table:

Company, Requesting Loc, Task, ID, Status
1000 ABC Level 1 smi4283 Active
1000 ABC Level 1 joh1111 Inactive


Results:
Requesting Loc, Task, ID, Status ID Task Status
ABC Level 1 joh1111 Inactive smi4283 Level 1 Active

re: query based on another query

since you are using subquery and specialluy in your case it is a in-line view.
and performance wise that is the best thing to do.