APPS.CE_AUTO_BANK_MATCH dependencies on AR_SYSTEM_PARAMETERS

Line 6421: FROM ar_system_parameters s

6417: -- moved from match_process
6418: -- bug 1796965
6419: SELECT count(*)
6420: INTO accounting_method_found
6421: FROM ar_system_parameters s
6422: where s.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id);
6423:
6424: if (accounting_method_found = 1) then
6425: SELECT accounting_method

Line 6427: FROM ar_system_parameters s

6423:
6424: if (accounting_method_found = 1) then
6425: SELECT accounting_method
6426: INTO CE_AUTO_BANK_MATCH.ar_accounting_method
6427: FROM ar_system_parameters s
6428: where s.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id);
6429: else
6430: CE_AUTO_BANK_MATCH.ar_accounting_method := NULL;
6431: end if;

Line 9806: FROM ar_system_parameters s

9802:
9803: -- bug 1796965
9804: SELECT count(*)
9805: INTO accounting_method_found
9806: FROM ar_system_parameters s
9807: where s.org_id = CE_AUTO_BANK_REC.G_org_id;
9808:
9809: if (accounting_method_found = 1) then
9810: SELECT accounting_method

Line 9812: FROM ar_system_parameters s

9808:
9809: if (accounting_method_found = 1) then
9810: SELECT accounting_method
9811: INTO CE_AUTO_BANK_MATCH.ar_accounting_method
9812: FROM ar_system_parameters s
9813: where s.org_id = CE_AUTO_BANK_REC.G_org_id;
9814: else
9815: CE_AUTO_BANK_MATCH.ar_accounting_method := NULL;
9816: end if;

Line 9875: FROM ar_system_parameters s

9871:
9872: -- bug 1796965
9873: SELECT count(*)
9874: INTO accounting_method_found
9875: FROM ar_system_parameters s
9876: where s.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
9877:
9878: if (accounting_method_found = 1) then
9879: SELECT accounting_method

Line 9881: FROM ar_system_parameters s

9877:
9878: if (accounting_method_found = 1) then
9879: SELECT accounting_method
9880: INTO CE_AUTO_BANK_MATCH.ar_accounting_method
9881: FROM ar_system_parameters s
9882: where s.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
9883: else
9884: CE_AUTO_BANK_MATCH.ar_accounting_method := NULL;
9885: end if;