DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on FND_CURRENCIES

Line 3159: FROM fnd_currencies c

3155: -- Get currency attributes
3156: CURSOR l_curr_csr(cp_currency_code VARCHAR2) IS
3157: SELECT c.minimum_accountable_unit,
3158: c.PRECISION
3159: FROM fnd_currencies c
3160: WHERE c.currency_code = cp_currency_code;
3161: */
3162: -- Get currency attributes
3163: CURSOR l_curr_csr(p_khr_id number) IS

Line 3166: FROM fnd_currencies c,

3162: -- Get currency attributes
3163: CURSOR l_curr_csr(p_khr_id number) IS
3164: SELECT c.minimum_accountable_unit,
3165: c.PRECISION
3166: FROM fnd_currencies c,
3167: okl_trx_ar_invoices_b b
3168: WHERE c.currency_code = b.currency_code
3169: AND b.khr_id = p_khr_id;
3170:

Line 3172: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

3168: WHERE c.currency_code = b.currency_code
3169: AND b.khr_id = p_khr_id;
3170:
3171:
3172: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3173: l_precision fnd_currencies.PRECISION %TYPE;
3174:
3175: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
3176:

Line 3173: l_precision fnd_currencies.PRECISION %TYPE;

3169: AND b.khr_id = p_khr_id;
3170:
3171:
3172: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3173: l_precision fnd_currencies.PRECISION %TYPE;
3174:
3175: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
3176:
3177: -- to get inventory_org_id bug 4890024 begin