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

Multiple SQL statements in one single Application Engine SQL Action

%Execute([/])
statment1{; | /}
statment2{; | /}
statment3{; | /}

ex:

%Execute(/)
statment1
/
statement2
/
statement3
/

How to find PeopleSoft current bundle number

use below Sql in DESCR place you can get bundle number info

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 3 DESC

Some good peoplesoft blogs :

http://peoplesofthrms.blogspot.in

To restrict  Component Interface to execute the code

using  %CompIntfcName  you'll get component interface name

If %CompIntfcName <> "Your CI name" then
Messagebox("Message")
End-If

The above condition will restrict the message box from executing when the People code is executed from your CI.