HRS_PAYMODE_VW

(SQL View)
 Index Back

Payment Mode Description

Fetches the Payment Mode Descriptions for Offer Components

SELECT A.OFFER_COMPONENT , X.XLATLONGNAME FROM PSXLATITEM X , PS_HRS_OFF_CMPNT A WHERE X.FIELDNAME = 'MONETARY_IND' AND X.FIELDVALUE = A.MONETARY_IND UNION SELECT A.OFFER_COMPONENT , X.XLATLONGNAME FROM PSXLATITEM X , PS_HRS_OFF_CMPNT A WHERE X.FIELDNAME = 'MONETARY_IND' AND X.FIELDVALUE = 'Y' AND A.MONETARY_IND = ' '

  • Related Language Record: HRS_PAYMODE_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OFFER_COMPONENT Character(7) VARCHAR2(7) NOT NULL Offer Component
    2 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description