DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_INTERIM_CASH_RECEIPTS

Line 3404: ar_interim_cash_receipts cash

3400: and transmission_record_id in (
3401: select overflow.transmission_record_id
3402: from ar_payments_interface payment, ar_payments_interface overflow,
3403: ar_trans_record_formats format, ar_transmissions transmissions,
3404: ar_interim_cash_receipts cash
3405: where payment.check_number = cash.receipt_number
3406: and payment.transmission_request_id = overflow.transmission_request_id
3407: and payment.item_number = overflow.item_number
3408: and nvl(payment.batch_name, -1) = nvl(overflow.batch_name, -1)

Line 3448: from ar_interim_cash_receipts

3444: where customer_trx_id = p_customer_trx_id;
3445:
3446: select currency_code
3447: into l_currency_code
3448: from ar_interim_cash_receipts
3449: where cash_receipt_id = p_cash_receipt_id;
3450:
3451: select count(distinct status)
3452: into status_count