SCC_VISA_CNT_VW

(SQL View)
 Index Back

Country view

Used as prompt for Visa Types in CC Fluid Profile Configuration

SELECT Country , Descr FROM %Table(Country_tbl) Country WHERE EXISTS( SELECT Country FROM PS_VISA_PERMIT_TBL A WHERE Country = Country.Country AND %EffdtCheck(VISA_PERMIT_TBL B, A, %CurrentDatein) AND Eff_status='A')

  • Related Language Record: SCC_VISA_CNTLNV

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