GPES_TX2_SH_LNG

(SQL View)
 Index Back

IRPF Search record rel lang

IRPF Search record related language

SELECT DISTINCT A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_YEAR , A.GPES_MONTH , CLANG.LANGUAGE_CD , BLANG.DESCR ,CLANG.DESCR FROM PS_GPES_TAX2_RSLT A , PS_COMPANY_TBL B , PS_COMPNY_TBL_LANG BLANG , PS_GPES_TAX_LOCATN C , PS_GPES_TAX_LOCLNG CLANG WHERE A.COMPANY = B.COMPANY AND B.COMPANY = BLANG.COMPANY AND A.GPES_TAX_LOCATION = C.GPES_TAX_LOCATION AND C.GPES_TAX_LOCATION = CLANG.GPES_TAX_LOCATION AND BLANG.LANGUAGE_CD = CLANG.LANGUAGE_CD AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_COMPANY_TBL D WHERE D.COMPANY = A.COMPANY AND D.EFFDT <= A.EFFDT) AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_GPES_TAX_LOCATN E WHERE E.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND E.EFFDT <= A.EFFDT) AND CLANG.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_GPES_TAX_LOCLNG F WHERE F.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND F.EFFDT <= A.EFFDT) UNION SELECT DISTINCT A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_YEAR , A.GPES_MONTH , CLANG.LANGUAGE_CD , ' ' , CLANG.DESCR FROM PS_GPES_TAX2_RSLT A , PS_GPES_TAX_LOCATN C , PS_GPES_TAX_LOCLNG CLANG WHERE NOT EXISTS ( SELECT 'X' FROM PS_COMPANY_TBL B WHERE B.COMPANY = A.COMPANY) AND A.GPES_TAX_LOCATION = C.GPES_TAX_LOCATION AND C.GPES_TAX_LOCATION = CLANG.GPES_TAX_LOCATION AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_GPES_TAX_LOCATN E WHERE E.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND E.EFFDT <= A.EFFDT) AND CLANG.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_GPES_TAX_LOCLNG F WHERE F.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND F.EFFDT <= A.EFFDT)

  • Related Language Record for GPES_TAX2_SH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

    Prompt Table: GPES_TAX_LOCATN

    3 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
    4 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR1 Character(30) VARCHAR2(30) NOT NULL Description