APPS.OKL_INS_QUOTE_PVT dependencies on FND_CURRENCIES_VL

Line 4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:
4662: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
4663: SELECT currency_code , deal_type, AUTHORING_ORG_ID
4664: FROM okl_k_headers_full_v

Line 5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:
5382: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
5383: SELECT currency_code, start_date
5384: FROM okl_k_headers_full_v

Line 5705: FROM fnd_currencies_vl

5701:
5702: --Get contract currency Precision
5703: CURSOR c_currency_precision(p_currency_code VARCHAR2) IS
5704: SELECT PRECISION
5705: FROM fnd_currencies_vl
5706: WHERE currency_code = p_currency_code
5707: AND enabled_flag = 'Y'
5708: AND TRUNC(NVL(start_date_active, SYSDATE)) <= TRUNC(SYSDATE)
5709: AND TRUNC(NVL(end_date_active, SYSDATE)) >= TRUNC(SYSDATE);