5210: SELECT ps.payment_schedule_id,
5211: int.previous_customer_trx_id,
5212: int.interface_line_id,
5213: ps.selected_for_receipt_batch_id
5214: FROM ra_interface_lines int,
5215: ar_payment_schedules ps
5216: WHERE int.request_id = p_request_id
5217: AND int.previous_customer_trx_id IS NOT NULL
5218: AND int.previous_customer_trx_id = ps.customer_trx_id ;