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

To get Component interface information

Use below SQL to get CI assigned permission list

SELECT * FROM PSAUTHBUSCOMP WHERE BCNAME='CI Name'

To get object migrated from which project

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME