PPP_ACT_BRA_VW

(SQL View)
 Index Back

PPP Actions

Actions for PPP

SELECT DISTINCT A.ACTION , B.DESCR FROM PS_PPP_PAR_ACT_BRA A , PS_ACTN_REASON_TBL B , PS_PPP_RC_BRA C WHERE A.ACTION = B.ACTION AND A.COMPANY = C.COMPANY AND A.PPP_PARAM_ID = C.PPP_PARAM_ID AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ACTN_REASON_TBL D WHERE D.ACTION = A.ACTION AND D.EFFDT <=%CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

2 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description