APPS.AR_AUTOREM_API dependencies on AR_AUTOREM_INTERIM

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

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
1193: cash_receipt_id,
1194: creation_status,--rc.creation_status
1195: org_id, -- cr.org_id

Line 1342: delete from ar_autorem_interim where batch_id = o_batch_id;

1338: END IF;
1339:
1340: END LOOP;
1341:
1342: delete from ar_autorem_interim where batch_id = o_batch_id;
1343: END IF;
1344: /* Bug 5051186 Update the Batch Status */
1345: IF l_format_flag = 'Y' THEN
1346: l_batch_applied_status := 'COMPLETED_FORMAT';

Line 2674: FROM ar_autorem_interim

2670: receipt_number,
2671: unique_ref,
2672: customer_bank_account_id,
2673: payment_trxn_extension_id
2674: FROM ar_autorem_interim
2675: WHERE batch_id = :ab_batch_id
2676: AND current_worker = :h_worker_number
2677: ';
2678:

Line 4395: FROM ar_autorem_interim a

4391: a.pay_from_customer,
4392: a.customer_site_use_id,
4393: a.payment_trxn_extension_id,
4394: a.batch_id
4395: FROM ar_autorem_interim a
4396: WHERE a.batch_id = p_batch_id
4397: AND a.current_worker = WORKER_NUMBER;
4398:
4399: