The status information for a project is going to be the same as it is for a request. Of course, the verbiage for the status is in the kcrt_statuses view where you would like the status_id in the kcrt_requests table to the status_id in the kcrt_statuses view.
Looking at your original posted query, you are looking for the request_type_id, not the request_id. A project is going to have a different request_type_id than other requests. You would want to use a query that looks like this:
select ks.status_name from kcrt_statuses ks, kcrt_requests kr
where kr.status_id = ks.status_id
and kr.request_id = [REQUEST_ID_OF_PROJECT]
Make sure you are using the request id and not the project id. Those are two different numbers.
I think you missed my point. The documentation isn't sufficient to get you everything you are trying to pull out. Prime example: you want to see where in the DB the Project Settings are stored for a project.
I'm not saying throw away the documentation, but I've found it much more efficient to be able to "follow the data" using SQL Developer than trying to dig through a 1300 page document and not find the answer I need.