[Home] [Help]
214: CURSOR C_DATE(P_SOB_CCY IN VARCHAR2,L_CON_TYPE IN VARCHAR2) IS
215: SELECT
216: MAX(CONVERSION_DATE)
217: FROM
218: GL_DAILY_RATES
219: WHERE FROM_CURRENCY = X_BASE_CCY
220: AND TO_CURRENCY = P_SOB_CCY
221: AND CONVERSION_TYPE = L_CON_TYPE
222: AND CONVERSION_DATE <= P_AS_OF_DATE_1;