GPBR_COMPWM_VW

(SQL View)
 Index Back

Company Table Brazil

Company Table Brazil

SELECT A.COMPANY ,B.DESCR FROM PS_GPBR_C_PARM_SRC A , PS_COMPANY_TBL B , PS_GPBR_COMP_P_EFF C WHERE A.COMPANY = B.COMPANY AND C.COMPANY = B.COMPANY AND C.GPBR_COMP_STATUS = 'E' AND A.GPBR_ES_ADHERE = ( SELECT MAX(A2.GPBR_ES_ADHERE) FROM PS_GPBR_C_PARM_SRC A2 WHERE A.COMPANY = A2.COMPANY) AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_COMPANY_TBL B2 WHERE B2.COMPANY = B.COMPANY AND B2.EFFDT <= A.GPBR_ES_ADHERE) AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_GPBR_COMP_P_EFF C2 WHERE C2.COMPANY = C.COMPANY AND C2.EFFDT <= %CurrentDateIn)

  • Related Language Record: GPBR_CMP_LNG_VW

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