APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on FND_CURRENCIES

Line 3942: FROM fnd_currencies cur, gl_sets_of_books sob

3938: ORDER BY trx_line_id, trx_level_type, account_source_tax_rate_id nulls first;
3939:
3940: CURSOR get_funcl_curr_info_csr (c_ledger_id ZX_LINES.LEDGER_ID%TYPE) IS
3941: SELECT cur.currency_code
3942: FROM fnd_currencies cur, gl_sets_of_books sob
3943: WHERE sob.set_of_books_id = c_ledger_id
3944: AND cur.currency_code = sob.currency_code;
3945:
3946: l_funcl_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 3946: l_funcl_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

3942: FROM fnd_currencies cur, gl_sets_of_books sob
3943: WHERE sob.set_of_books_id = c_ledger_id
3944: AND cur.currency_code = sob.currency_code;
3945:
3946: l_funcl_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3947: l_error_buffer VARCHAR2(240);
3948: BEGIN
3949:
3950: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4713: FROM fnd_currencies cur, gl_sets_of_books sob

4709:
4710: CURSOR get_mau_info_csr IS
4711: SELECT nvl( cur.minimum_accountable_unit, power( 10, (-1 * precision))),
4712: cur.currency_code
4713: FROM fnd_currencies cur, gl_sets_of_books sob
4714: WHERE sob.set_of_books_id = p_ledger_id
4715: AND cur.currency_code = sob.currency_code;
4716:
4717: TYPE rec_nrec_tax_dist_id_tbl_type IS TABLE OF

Line 4803: l_funcl_currency_code fnd_currencies.currency_code%TYPE;

4799: l_rec_begin_index NUMBER;
4800: l_nrec_begin_index NUMBER;
4801:
4802: l_minimum_accountable_unit NUMBER;
4803: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
4804:
4805: BEGIN
4806:
4807: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 5582: FROM fnd_currencies cur, gl_sets_of_books sob

5578: p_unrounded_amt NUMBER ) RETURN NUMBER IS
5579:
5580: CURSOR get_mau_info_csr IS
5581: SELECT nvl( cur.minimum_accountable_unit, power( 10, (-1 * precision)))
5582: FROM fnd_currencies cur, gl_sets_of_books sob
5583: WHERE sob.set_of_books_id = p_ledger_id
5584: AND cur.currency_code = sob.currency_code;
5585:
5586: l_rounded_amt_to_mau NUMBER;