APPS.OKL_PRICING_PVT dependencies on FND_CURRENCIES

Line 3584: FROM fnd_currencies a,

3580: -- To get the Currency code and Precision
3581: CURSOR get_curr_code_pre(p_khr_id NUMBER)
3582: IS
3583: SELECT NVL(a.precision,0) precision
3584: FROM fnd_currencies a,
3585: okc_k_headers_b b
3586: WHERE b.currency_code = a.currency_code
3587: AND b.id = p_khr_id;
3588: -- To get the Contract Start date

Line 5513: FROM fnd_currencies

5509: WHERE id = p_khr_id;
5510:
5511: SELECT NVL(precision,0)
5512: INTO l_precision
5513: FROM fnd_currencies
5514: WHERE currency_code = l_currency_code;
5515:
5516:
5517: l_precision := 4;

Line 6786: FROM fnd_currencies a,

6782: -- To get the Currency code and Precision
6783: CURSOR get_curr_code_pre(p_khr_id NUMBER)
6784: IS
6785: SELECT NVL(a.precision,0) precision
6786: FROM fnd_currencies a,
6787: okc_k_headers_b b
6788: WHERE b.currency_code = a.currency_code
6789: AND b.id = p_khr_id;
6790:

Line 9349: FROM fnd_currencies

9345: WHERE id = p_khr_id;
9346:
9347: SELECT NVL(precision,0)
9348: INTO l_precision
9349: FROM fnd_currencies
9350: WHERE currency_code = l_currency_code;
9351:
9352: l_iir_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
9353: --print( 'Initial iir estimated ' || l_iir );

Line 11197: FROM fnd_currencies_vl

11193: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4);
11194:
11195: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
11196: SELECT PRECISION
11197: FROM fnd_currencies_vl
11198: WHERE currency_code = p_currency_code
11199: AND enabled_flag = 'Y'
11200: AND NVL(start_date_active, SYSDATE) <= SYSDATE
11201: AND NVL(end_date_active, SYSDATE) >= SYSDATE;