DBA Data[Home] [Help]

APPS.ARRX_ADJ dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 172: from ar_system_parameters_all

168: elsif p_reporting_level = 3000 then
169:
170: select set_of_books_id
171: into var.books_id
172: from ar_system_parameters_all
173: where org_id = p_reporting_entity;
174:
175: mo_global.init('AR');
176: mo_global.set_policy_context('S',p_reporting_entity);

Line 302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;

298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts
301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
303: IF var.p_reporting_level = 3000 then
304: Select decode(nvl(sla_ledger_cash_basis_flag, 'N'),'N', 'ACCRUAL', 'CASH')
305: into ACCOUNTING_METHOD
306: from gl_ledgers