WCS_CFG_PGLT_LV

(SQL View)
 Index Back

Compensation Chart Pagelets

Gets related language descriptions for pagelets configured and available for compensation components.

SELECT PCFG.PNLGRPNAME , PCFG.PTPPB_PAGELET_ID , PTPGLT.LANGUAGE_CD , PTPGLT.DESCR FROM PS_WCS_PGLT_CONFIG PCFG , PS_PTPPB_PGLT_LANG PTPGLT WHERE PCFG.PTPPB_PAGELET_ID = PTPGLT.PTPPB_PAGELET_ID

  • Related Language Record for WCS_CFG_PGLT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description