DBA Data[Home] [Help]

APPS.ARRX_ADJ dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 173: from ar_system_parameters_all

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

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

299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
302: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
303: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
304: IF var.p_reporting_level = 3000 then
305: IF var.p_reporting_entity_id IS NOT NULL THEN
306: execute immediate acct_stmt into ACCOUNTING_METHOD using var.p_reporting_entity_id, var.p_reporting_entity_id;
307: END IF;