DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on FND_CURRENCIES

Line 990: FROM fnd_currencies c

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

Line 997: FROM fnd_currencies c,

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:

Line 1003: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

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:

Line 1004: l_precision fnd_currencies.PRECISION %TYPE;

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