DBA Data[Home] [Help]

APPS.ARRX_RC dependencies on GL_SETS_OF_BOOKS

Line 154: from GL_SETS_OF_BOOKS

150: fa_rx_util_pkg.debug('Get COA ID');
151:
152: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
153: into var.chart_of_accounts_id,var.currency_code,var.org_name
154: from GL_SETS_OF_BOOKS
155: where SET_OF_BOOKS_ID = var.books_id;
156:
157: --
158: -- Figure out NOCOPY the where clause for the parameters

Line 567: from GL_SETS_OF_BOOKS

563: --Bug 5244313 added the var.books_id in the where clause to pickup the sob based on the reporting context
564: -- if p_sob_id is null
565: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
566: into var.p_coa_id,var.functional_currency_code,var.organization_name
567: from GL_SETS_OF_BOOKS
568: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
569:
570: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);