796:
797: IF p_party_id IS NOT NULL THEN
798: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
799: INTO l_nsf_stop_payment_amount
800: FROM ar_cash_receipts_all cr,
801: ar_cash_receipt_history_all crh,
802: hz_cust_accounts ca
803: WHERE cr.cash_receipt_id = crh.cash_receipt_id
804: AND crh.current_record_flag = 'Y'
815: AND ca.party_id = p_party_id;
816: ELSIF p_cust_account_id IS NOT NULL THEN
817: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
818: INTO l_nsf_stop_payment_amount
819: FROM ar_cash_receipts_all cr,
820: ar_cash_receipt_history_all crh
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id
822: AND crh.current_record_flag = 'Y'
823: AND crh.status = 'REVERSED'
832: AND cr.pay_from_customer = p_cust_account_id;
833: ELSIF p_customer_site_use_id IS NOT NULL THEN
834: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
835: INTO l_nsf_stop_payment_amount
836: FROM ar_cash_receipts_all cr,
837: ar_cash_receipt_history_all crh
838: WHERE cr.cash_receipt_id = crh.cash_receipt_id
839: AND crh.current_record_flag = 'Y'
840: AND crh.status = 'REVERSED'