19:
20: -- Bug 15868325
21: cursor c_get_sob_corp_cur is
22: select glcr.ledger_id
23: from gl_ledgers gltr,
24: fa_mc_book_controls mcbc,
25: gl_ledgers glcr
26: where gltr.ledger_id = p_set_of_books_id
27: and gltr.currency_code = glcr.currency_code
21: cursor c_get_sob_corp_cur is
22: select glcr.ledger_id
23: from gl_ledgers gltr,
24: fa_mc_book_controls mcbc,
25: gl_ledgers glcr
26: where gltr.ledger_id = p_set_of_books_id
27: and gltr.currency_code = glcr.currency_code
28: and gltr.chart_of_accounts_id = glcr.chart_of_accounts_id
29: and gltr.ledger_id <> glcr.ledger_id