GP_CNTRY_SS_VW

(SQL View)
 Index Back

Country prompt self-service

Prompt for country on add search record for country/take self-service configuration.

SELECT DISTINCT A.COUNTRY ,C.DESCR FROM PS_GP_ABS_TYPE A , PS_COUNTRY_TBL C , PS_GP_OPR_RULE_PRF G WHERE (A.REQUEST_IND = 'Y' AND A.COUNTRY = C.COUNTRY) OR ((G.USED_BY = 'A' OR A.COUNTRY = G.COUNTRY) AND A.COUNTRY = C.COUNTRY) AND A.EFF_STATUS = 'A' AND %EffdtCheck(GP_ABS_TYPE, A, %CURRENTDATEIN) AND A.COUNTRY IN ( SELECT DISTINCT D.COUNTRY FROM PS_GP_ABS_SS_CNTRY D)

  • Related Language Record: GP_ABSCTRY_LVW

    • # 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