DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_CASH_RECEIPT_HISTORY

Line 552: ar_cash_receipt_history crh

548: SELECT COUNT(DISTINCT ps.payment_schedule_id)
549: INTO l_auto_rec_approved_count
550: FROM ar_payment_schedules ps,
551: ar_receivable_applications ra,
552: ar_cash_receipt_history crh
553: WHERE ps.customer_trx_id = p_customer_trx_id
554: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
555: AND ra.cash_receipt_id = crh.cash_receipt_id
556: AND ps.selected_for_receipt_batch_id = crh.batch_id