APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_PAYMENT_SCHEDULES

Line 616: FROM ar_payment_schedules

612: My main concern was the status=OP part.. snort! we are reversing
613: a receipt on a closed transaction! */
614: SELECT sum(amount_due_remaining), trunc(sysdate) - trunc(max(due_date))
615: INTO l_cc_trx_amount, l_days_late
616: FROM ar_payment_schedules
617: WHERE customer_trx_id = p_customer_trx_id
618: AND selected_for_receipt_batch_id IS NULL
619: AND reserved_type IS NULL
620: AND reserved_value IS NULL;