HR_OBD_PCKG_VW

(SQL View)
 Index Back

App Class Roots


SELECT A.PACKAGEROOT , A.DESCR FROM PSPACKAGEDEFN A WHERE A.PACKAGEID = A.PACKAGEROOT AND ( (A.PACKAGEID = 'HR_OBD_CONTROLLER') OR EXISTS ( SELECT 'X' FROM PSPCMTXT B WHERE B.OBJECTID1 = 104 AND B.OBJECTVALUE1 = A.PACKAGEROOT AND B.PCTEXT LIKE '%extends HR_OBD_USER_PROFILE:UserProfile%'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description