GP_R_PKG_VW

(SQL View)
 Index Back

Retrieves regular rule pkgs

Retrieves regular rule pkgs

SELECT GP_PKG_ID , DESCR FROM PS_GP_PKG_DFN WHERE ((GP_VERSION_IND = 'N') AND (GP_PKG_ID NOT IN ( SELECT DISTINCT GP_PKG_ID FROM PS_GP_PKG_CRIT2)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging

Prompt Table: GP_R_PKG_VW

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description