Patrick Lee 03-04-99: Selects the Rate Types that are valid for a particular currency code. SELECT A.TO_CUR, A.RT_TYPE FROM PS_RT_RATE_TBL A, PS_RT_INDEX_TBL B, PS_RUN_CNTL_PL C WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_RT_RATE_TBL WHERE A.RT_RATE_INDEX = RT_RATE_INDEX AND A.TERM = TERM AND A.FROM_CUR = FROM_CUR AND A.TO_CUR = TO_CUR AND A.RT_TYPE = RT_TYPE AND EFFDT <= SUBSTRING(CONVERT(CHAR,GETDATE()),1,11)) AND A.RT_RATE_INDEX = B.RT_RATE_INDEX AND B.DEFAULT_INDEX = 'Y' 09/01/99 EGS: added distinct

RT_TYPE_EP_VW

(SQL View)
 Index Back

SELECT DISTINCT A.TO_CUR , A.RT_TYPE FROM PS_RT_RATE_TBL A , PS_RT_INDEX_TBL B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RT_RATE_TBL WHERE A.RT_RATE_INDEX = RT_RATE_INDEX AND A.TERM = TERM AND A.FROM_CUR = FROM_CUR AND A.TO_CUR = TO_CUR AND A.RT_TYPE = RT_TYPE AND EFFDT <= %CurrentDateIn) AND A.RT_RATE_INDEX = B.RT_RATE_INDEX AND B.DEFAULT_INDEX = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BASE_CURRENCY_EP Character(3) VARCHAR2(3) NOT NULL Base Currency for EP
2 RT_TYPE_EP Character(5) VARCHAR2(5) NOT NULL Rate Type for EP