WP_AGRT_A_PD_VW

(SQL View)
 Index Back

SELECT DISTINCT A.WP_AGREEMENT_ID , B.PERIOD_ID FROM PS_WP_AGREEMENT A , PS_WP_AGRT_PERIOD B WHERE A.WP_AGRT_STATUS = 'A' AND A.WP_AGREEMENT_ID = B.WP_AGREEMENT_ID AND B.WP_PERIOD_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WP_AGREEMENT_ID Character(5) VARCHAR2(5) NOT NULL Profit-Sharing: Agreement Identifier
2 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID