APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_PAYMENT_SCHEDULES

Line 625: FROM ar_payment_schedules

621: My main concern was the status=OP part.. snort! we are reversing
622: a receipt on a closed transaction! */
623: SELECT sum(amount_due_remaining), trunc(sysdate) - trunc(max(due_date))
624: INTO l_cc_trx_amount, l_days_late
625: FROM ar_payment_schedules
626: WHERE customer_trx_id = p_customer_trx_id
627: AND selected_for_receipt_batch_id IS NULL
628: AND reserved_type IS NULL
629: AND reserved_value IS NULL;