986: -- Get currency attributes
987: CURSOR l_curr_csr(cp_currency_code VARCHAR2) IS
988: SELECT c.minimum_accountable_unit,
989: c.PRECISION
990: FROM fnd_currencies c
991: WHERE c.currency_code = cp_currency_code;
992: */
993: -- Get currency attributes
994: CURSOR l_curr_csr(p_khr_id number) IS
993: -- Get currency attributes
994: CURSOR l_curr_csr(p_khr_id number) IS
995: SELECT c.minimum_accountable_unit,
996: c.PRECISION
997: FROM fnd_currencies c,
998: okl_trx_ar_invoices_b b
999: WHERE c.currency_code = b.currency_code
1000: AND b.khr_id = p_khr_id;
1001:
999: WHERE c.currency_code = b.currency_code
1000: AND b.khr_id = p_khr_id;
1001:
1002:
1003: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1004: l_precision fnd_currencies.PRECISION %TYPE;
1005:
1006: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
1007:
1000: AND b.khr_id = p_khr_id;
1001:
1002:
1003: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1004: l_precision fnd_currencies.PRECISION %TYPE;
1005:
1006: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
1007:
1008: -- to get inventory_org_id bug 4890024 begin