APPS.OKL_PRICING_PVT dependencies on FND_CURRENCIES

Line 3184: FROM fnd_currencies a,

3180: -- To get the Currency code and Precision
3181: CURSOR get_curr_code_pre(p_khr_id NUMBER)
3182: IS
3183: SELECT NVL(a.precision,0) precision
3184: FROM fnd_currencies a,
3185: okc_k_headers_b b
3186: WHERE b.currency_code = a.currency_code
3187: AND b.id = p_khr_id;
3188: -- To get the Contract Start date

Line 5123: FROM fnd_currencies

5119: WHERE id = p_khr_id;
5120:
5121: SELECT NVL(precision,0)
5122: INTO l_precision
5123: FROM fnd_currencies
5124: WHERE currency_code = l_currency_code;
5125:
5126:
5127: l_precision := 4;

Line 6396: FROM fnd_currencies a,

6392: -- To get the Currency code and Precision
6393: CURSOR get_curr_code_pre(p_khr_id NUMBER)
6394: IS
6395: SELECT NVL(a.precision,0) precision
6396: FROM fnd_currencies a,
6397: okc_k_headers_b b
6398: WHERE b.currency_code = a.currency_code
6399: AND b.id = p_khr_id;
6400:

Line 8964: FROM fnd_currencies

8960: WHERE id = p_khr_id;
8961:
8962: SELECT NVL(precision,0)
8963: INTO l_precision
8964: FROM fnd_currencies
8965: WHERE currency_code = l_currency_code;
8966:
8967: l_iir_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
8968: --print( 'Initial iir estimated ' || l_iir );

Line 10819: FROM fnd_currencies_vl

10815: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4);
10816:
10817: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
10818: SELECT PRECISION
10819: FROM fnd_currencies_vl
10820: WHERE currency_code = p_currency_code
10821: AND enabled_flag = 'Y'
10822: AND NVL(start_date_active, SYSDATE) <= SYSDATE
10823: AND NVL(end_date_active, SYSDATE) >= SYSDATE;