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 1038: FROM fnd_currencies_vl

1034:
1035: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
1036: IS
1037: SELECT PRECISION
1038: FROM fnd_currencies_vl
1039: WHERE currency_code = p_currency_code
1040: AND enabled_flag = 'Y'
1041: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1042: AND NVL(end_date_active, SYSDATE) >= SYSDATE;