DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on FND_CURRENCIES

Line 382: FROM fnd_currencies c

378:
379: -- Get currency attributes
380: CURSOR l_curr_csr (cp_currency_code VARCHAR2) IS
381: SELECT c.minimum_accountable_unit, c.precision
382: FROM fnd_currencies c
383: WHERE c.currency_code = cp_currency_code;
384:
385: -- Get Currency Code
386: CURSOR get_curr_code_csr ( p_sob_id NUMBER ) IS

Line 392: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

388: FROM GL_LEDGERS_PUBLIC_V
389: WHERE ledger_id = p_sob_id;
390:
391:
392: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
393: l_precision fnd_currencies.precision%TYPE;
394: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
395: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
396: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;

Line 393: l_precision fnd_currencies.precision%TYPE;

389: WHERE ledger_id = p_sob_id;
390:
391:
392: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
393: l_precision fnd_currencies.precision%TYPE;
394: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
395: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
396: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;
397: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;

Line 1803: FROM fnd_currencies c

1799:
1800: -- Get currency attributes
1801: CURSOR l_curr_csr (cp_currency_code VARCHAR2) IS
1802: SELECT c.minimum_accountable_unit, c.precision
1803: FROM fnd_currencies c
1804: WHERE c.currency_code = cp_currency_code;
1805:
1806: -- Get Currency Code
1807: CURSOR get_curr_code_csr ( p_sob_id NUMBER ) IS

Line 1813: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

1809: FROM GL_LEDGERS_PUBLIC_V
1810: WHERE ledger_id = p_sob_id;
1811:
1812:
1813: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1814: l_precision fnd_currencies.precision%TYPE;
1815: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
1816: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
1817: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;

Line 1814: l_precision fnd_currencies.precision%TYPE;

1810: WHERE ledger_id = p_sob_id;
1811:
1812:
1813: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1814: l_precision fnd_currencies.precision%TYPE;
1815: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
1816: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
1817: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;
1818: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;