DBA Data[Home] [Help]

APPS.OKL_STREAMS_UTIL dependencies on FND_CURRENCIES_VL

Line 237: FROM fnd_currencies_vl

233: -- Get the precision for the amounts to Round
234: -- Depending on the Currency code
235: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
236: SELECT PRECISION
237: FROM fnd_currencies_vl
238: WHERE currency_code = p_currency_code
239: AND enabled_flag = 'Y'
240: AND NVL(start_date_active, SYSDATE) <= SYSDATE
241: AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line 2036: FROM fnd_currencies_vl

2032: -- Get the precision for the amounts to Round
2033: -- Depending on the Currency code
2034: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
2035: SELECT PRECISION
2036: FROM fnd_currencies_vl
2037: WHERE currency_code = p_currency_code
2038: AND enabled_flag = 'Y'
2039: AND NVL(start_date_active, SYSDATE) <= SYSDATE
2040: AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line 2505: FROM fnd_currencies_vl

2501:
2502: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
2503: IS
2504: SELECT PRECISION
2505: FROM fnd_currencies_vl
2506: WHERE currency_code = p_currency_code
2507: AND enabled_flag = 'Y'
2508: AND NVL(start_date_active, SYSDATE) <= SYSDATE
2509: AND NVL(end_date_active, SYSDATE) >= SYSDATE;