To get project information based on object name :

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B

WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME