Looking for Sql query which pull the Request for information workflow

I am looking for a report which help to get Requisition and Request for information details

I used the below query to pull the details. I am getting the result, But I need only the PR which are still in open for Request for Information action. PRs which already submitted the information's should be removed from the query.

select distinct
hou.name,
prha.segment1 Req,
pah.action_code,
pah.NOTE,
pah.action_date Requested_Date,
papf.full_name Requested_by,
prha.authorization_status
from
apps.po_action_history pah,
apps.po_requisition_headers_all prha,
apps.per_all_people_f papf,