DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_SYSTEM_PARAMETERS

Line 1188: FROM ar_system_parameters;

1184: END;
1185: --fetch org id,need to set it for child requests
1186: SELECT org_id
1187: INTO l_org_id
1188: FROM ar_system_parameters;
1189: fnd_file.put_line( FND_FILE.LOG, 'Populating interim table ....'||l_count);
1190: IF l_count > 0 THEN
1191: l_ins_stmt := 'INSERT /*+ append */ INTO ar_autorem_interim
1192: (receipt_number, --cr.receipt_number

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

1524: select bbt.bank_branch_id ,bbt.remit_account_id
1525: from ap_bank_branches bbt
1526: where bbt.bank_branch_id in
1527: (select distinct bb.bank_branch_id
1528: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1529: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1530: and rma.bank_account_id = ba.bank_account_id
1531: and ( ba.currency_code = p_currency_code
1532: or ba.receipt_multi_currency_flag = 'Y' )

Line 1678: FROM ar_system_parameters asp,

1674: pinvoices_per_commit,
1675: preceipts_per_commit,
1676: pfunctional_currency,
1677: pacc_method
1678: FROM ar_system_parameters asp,
1679: gl_sets_of_books gsob,
1680: ar_batches ab
1681: WHERE ab.batch_id = p_batch_id
1682: AND ab.set_of_books_id = gsob.set_of_books_id