481: SELECT payment_schedule_id,
482: due_date,
483: amount_in_dispute,
484: dispute_date
485: FROM ar_payment_schedules ps
486: WHERE ps.customer_trx_id = p_customer_trx_id;
487:
488: CURSOR c_item_type(l_item_key NUMBER) IS
489: SELECT item_type
502: where customer_trx_id = p_cust_trx_id;
503:
504: Cursor Get_paymentid(p_cust_trx_id number) Is
505: select customer_id,payment_schedule_id
506: from ar_payment_schedules
507: where customer_trx_id = p_cust_trx_id;
508:
509: BEGIN
510: