DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_SYSTEM_PARAMETERS

Line 1245: FROM ar_system_parameters;

1241: END;
1242: --fetch org id,need to set it for child requests
1243: SELECT org_id
1244: INTO l_org_id
1245: FROM ar_system_parameters;
1246: fnd_file.put_line( FND_FILE.LOG, 'Populating interim table ....'||l_count);
1247: IF l_count > 0 THEN
1248: IF PG_APPEND IN ('Y', 'C') THEN
1249: l_ins_stmt := 'INSERT /*+ append */ INTO ar_autorem_interim ';

Line 1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp

1588: select bbt.bank_branch_id ,bbt.remit_account_id
1589: from ap_bank_branches bbt
1590: where bbt.bank_branch_id in
1591: (select distinct bb.bank_branch_id
1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1593: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1594: and rma.bank_account_id = ba.bank_account_id
1595: and ( ba.currency_code = p_currency_code
1596: or ba.receipt_multi_currency_flag = 'Y' )

Line 1742: FROM ar_system_parameters asp,

1738: pinvoices_per_commit,
1739: preceipts_per_commit,
1740: pfunctional_currency,
1741: pacc_method
1742: FROM ar_system_parameters asp,
1743: gl_sets_of_books gsob,
1744: ar_batches ab
1745: WHERE ab.batch_id = p_batch_id
1746: AND ab.set_of_books_id = gsob.set_of_books_id