DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on FND_CURRENCIES

Line 1093: FROM fnd_currencies c

1089: -- Get currency attributes
1090: CURSOR l_curr_csr(cp_currency_code VARCHAR2) IS
1091: SELECT c.minimum_accountable_unit,
1092: c.PRECISION
1093: FROM fnd_currencies c
1094: WHERE c.currency_code = cp_currency_code;
1095: */
1096: -- Get currency attributes
1097: CURSOR l_curr_csr(p_khr_id number) IS

Line 1100: FROM fnd_currencies c,

1096: -- Get currency attributes
1097: CURSOR l_curr_csr(p_khr_id number) IS
1098: SELECT c.minimum_accountable_unit,
1099: c.PRECISION
1100: FROM fnd_currencies c,
1101: okl_trx_ar_invoices_b b
1102: WHERE c.currency_code = b.currency_code
1103: AND b.khr_id = p_khr_id;
1104:

Line 1106: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

1102: WHERE c.currency_code = b.currency_code
1103: AND b.khr_id = p_khr_id;
1104:
1105:
1106: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1107: l_precision fnd_currencies.PRECISION %TYPE;
1108:
1109: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
1110:

Line 1107: l_precision fnd_currencies.PRECISION %TYPE;

1103: AND b.khr_id = p_khr_id;
1104:
1105:
1106: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1107: l_precision fnd_currencies.PRECISION %TYPE;
1108:
1109: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
1110:
1111: -- to get inventory_org_id bug 4890024 begin