HCSC_CAL_APP_VW (SQL View)	Index Back
Appl Package Path View Application Package Path View used as a prompt table by Calendar Configurable Sections.

HCSC_CAL_APP_VW

(SQL View)

Appl Package Path View

Application Package Path View used as a prompt table by Calendar Configurable Sections.

SELECT DISTINCT %Sql(FUNCLIB_HR_STRING_RTRIM, PACKAGEROOT) %Concat ':' %Concat %Sql(FUNCLIB_HR_STRING_RTRIM, QUALIFYPATH) FROM PSAPPCLASSDEFN WHERE QUALIFYPATH <> ':' UNION SELECT PACKAGEROOT %Concat ':' FROM PSAPPCLASSDEFN WHERE QUALIFYPATH = ':'

Parent record: SI_PKGROOT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path