GVT_ROST_SRCH

(SQL View)
Index Back

SELECT A.COMPANY, B.DESCR FROM PS_GVT_ROST_CNTRL A, PS_COMPANY_TBL B WHERE A.COMPANY = B.COMPANY AND B.EFFDT = (SELECT MAX(B1.EFFDT) FROM PS_COMPANY_TBL B1 WHERE B1.COMPANY=A.COMPANY AND B1.EFFDT <= A.EFFDT)

  • Related Language Record: GVT_ROSTSRC_LNG
  • # 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