APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on GL_SETS_OF_BOOKS

Line 2628: FROM gl_sets_of_books

2624:
2625: -- Added following 2 cursors for Bug#13948234 --
2626: CURSOR get_chart_of_account(c_sob_id NUMBER) IS
2627: SELECT chart_of_accounts_id
2628: FROM gl_sets_of_books
2629: WHERE set_of_books_id = c_sob_id;
2630:
2631: CURSOR get_account_string (l_ccid NUMBER) IS
2632: SELECT SUBSTRB(concatenated_segments,1,250) account_string

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 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 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;