DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on FND_CURRENCIES_VL

Line 50: FROM fnd_currencies_vl

46: FROM okc_k_headers_v
47: WHERE id = p_contract_id;
48: CURSOR prec_cur (l_currency_code VARCHAR2) IS
49: SELECT precision
50: FROM fnd_currencies_vl
51: WHERE currency_code = l_currency_code
52: AND enabled_flag = 'Y'
53: AND NVL(start_date_active, SYSDATE) <= SYSDATE
54: AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line 985: FROM fnd_currencies_vl

981:
982: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
983: IS
984: SELECT PRECISION
985: FROM fnd_currencies_vl
986: WHERE currency_code = p_currency_code
987: AND enabled_flag = 'Y'
988: AND NVL(start_date_active, SYSDATE) <= SYSDATE
989: AND NVL(end_date_active, SYSDATE) >= SYSDATE;