[Home] [Help]
170: ORDER BY 2 DESC;
171:
172: CURSOR cur_currencies IS
173: SELECT currency_code
174: FROM Fnd_currencies
175: WHERE UPPER(enabled_flag) = 'Y'
176: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
177: AND NVL(end_date_active, SYSDATE)
178: ORDER BY 1;