APPS.AR_AUTOREM_API dependencies on AR_AUTOREM_INTERIM

Line 1249: l_ins_stmt := 'INSERT /*+ append */ INTO ar_autorem_interim ';

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 ';
1250: ELSE
1251: l_ins_stmt := 'INSERT INTO ar_autorem_interim ';
1252: END IF;
1253: l_ins_stmt := l_ins_stmt ||'

Line 1251: l_ins_stmt := 'INSERT INTO ar_autorem_interim ';

1247: IF l_count > 0 THEN
1248: IF PG_APPEND IN ('Y', 'C') THEN
1249: l_ins_stmt := 'INSERT /*+ append */ INTO ar_autorem_interim ';
1250: ELSE
1251: l_ins_stmt := 'INSERT INTO ar_autorem_interim ';
1252: END IF;
1253: l_ins_stmt := l_ins_stmt ||'
1254: (receipt_number, --cr.receipt_number
1255: cash_receipt_id,

Line 1405: delete from ar_autorem_interim where batch_id = o_batch_id;

1401: END IF;
1402:
1403: END LOOP;
1404:
1405: delete from ar_autorem_interim where batch_id = o_batch_id;
1406: END IF;
1407: /* Bug 5051186 Update the Batch Status */
1408: IF l_format_flag = 'Y' THEN
1409: l_batch_applied_status := 'COMPLETED_FORMAT';

Line 2738: FROM ar_autorem_interim

2734: receipt_number,
2735: unique_ref,
2736: customer_bank_account_id,
2737: payment_trxn_extension_id
2738: FROM ar_autorem_interim
2739: WHERE batch_id = :ab_batch_id
2740: AND current_worker = :h_worker_number
2741: ';
2742:

Line 4681: FROM ar_autorem_interim a,

4677: a.customer_site_use_id,
4678: a.payment_trxn_extension_id,
4679: a.batch_id,
4680: pr.home_country
4681: FROM ar_autorem_interim a,
4682: /* Need to pass country code for SEPA specific receipts */
4683: ar_cash_receipts_all cr,
4684: ce_bank_acct_uses bau,
4685: ce_bank_accounts cba,