RO_EMAIL_PKG_VW

(SQL View)
 Index Back

Email Package

This view is used to display the Active Email Templates for sending email notifications.

SELECT RB_PACKAGE_ID , RB_PACKAGE_NAME FROM PS_RBC_PACKAGE_DFN WHERE EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_PACKAGE_ID Number(10,0) DECIMAL(10) NOT NULL Package
2 RB_PACKAGE_NAME Character(30) VARCHAR2(30) NOT NULL Package Name