HRS_PAYMODE_LN

(SQL View)
 Index Back

Payment Mode Description

Fetches the Payment Mode Descriptions for Offer Components

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

  • Related Language Record for HRS_PAYMODE_VW

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