DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_INTERIM_CASH_RECEIPTS

Line 3432: ar_interim_cash_receipts cash

3428: and transmission_record_id in (
3429: select overflow.transmission_record_id
3430: from ar_payments_interface payment, ar_payments_interface overflow,
3431: ar_trans_record_formats format, ar_transmissions transmissions,
3432: ar_interim_cash_receipts cash
3433: where payment.check_number = cash.receipt_number
3434: and payment.transmission_request_id = overflow.transmission_request_id
3435: and payment.item_number = overflow.item_number
3436: and nvl(payment.batch_name, -1) = nvl(overflow.batch_name, -1)

Line 3467: from ar_interim_cash_receipts

3463: where customer_trx_id = p_customer_trx_id;
3464:
3465: select currency_code
3466: into l_currency_code
3467: from ar_interim_cash_receipts
3468: where cash_receipt_id = p_cash_receipt_id;
3469:
3470: select count(distinct status)
3471: into status_count