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
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:
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:
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