WCS_APRV_OPR_VW (SQL View)	Index Back
Get User List for Approvals Gets the list of users that have access to the compensation approvals component.

WCS_APRV_OPR_VW

(SQL View)

Get User List for Approvals

Gets the list of users that have access to the compensation approvals component.

SELECT RU.ROLEUSER FROM PSAUTHITEM PRM , PSROLECLASS RCL , PSROLEUSER RU WHERE PRM.PNLITEMNAME = 'WCS_ECM_AWE_HOME' AND PRM.CLASSID = RCL.CLASSID AND RCL.ROLENAME = RU.ROLENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User