SQL Statement with a Select Statement Inside a Where Clause
Here is what I ended up with:

Select Distinct rParent.REQ_ID
From REQUESTS rParent
Inner Join REQUESTS rChild On rChild.P_REQ_ID = rParent.REQ_ID
Where rParent.P_REQ_ID IS NULL