APPS.AR_PREPAYMENTS dependencies on AR_CASH_RECEIPT_HISTORY

Line 76: FROM AR_CASH_RECEIPT_HISTORY crh

72: (
73: NOT EXISTS
74: (
75: SELECT 1
76: FROM AR_CASH_RECEIPT_HISTORY crh
77: WHERE crh.cash_receipt_id = p_cash_receipt_id
78: AND crh.status IN ('REMITTED', 'CLEARED')
79: )
80: );

Line 733: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

729: --Bug 3106245
730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
731:
732: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
733: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
734: p_maturity_date IN DATE DEFAULT NULL,
735: p_postmark_date IN DATE DEFAULT NULL,
736: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
737: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,