APPS.AR_PUBLIC_UTILS dependencies on AR_CASH_RECEIPT_HISTORY

Line 83: AND EXISTS (SELECT status from ar_cash_receipt_history crh

79: SELECT cr.*
80: INTO l_receipt_header
81: FROM ar_cash_receipts cr
82: WHERE cr.payment_server_order_num=p_payment_server_order_num
83: AND EXISTS (SELECT status from ar_cash_receipt_history crh
84: WHERE crh.status = 'REMITTED'
85: AND crh.cash_receipt_id=cr.cash_receipt_id);
86:
87: END IF;