APPS.ARP_CMREQ_WF dependencies on AR_PAYMENT_SCHEDULES

Line 566: from ar_payment_schedules ps

562: sum(ps.freight_original), sum(ps.amount_due_original),
563: ps.invoice_currency_code
564: into p_original_line_amount , p_original_tax_amount,
565: p_original_freight_amount, p_original_total, p_currency_code
566: from ar_payment_schedules ps
567: where ps.customer_trx_id = p_customer_trx_id
568: group by ps.invoice_currency_code ;
569:
570: exception

Line 2919: FROM ar_payment_schedules ps

2915:
2916: /*
2917: CURSOR ps_cur(p_customer_trx_id NUMBER) IS
2918: SELECT payment_schedule_id, due_date, amount_in_dispute, dispute_date
2919: FROM ar_payment_schedules ps
2920: WHERE ps.customer_trx_id = p_customer_trx_id;
2921: */
2922:
2923: CURSOR ps_cur(p_customer_trx_id NUMBER) IS

Line 2925: FROM ar_payment_schedules ps

2921: */
2922:
2923: CURSOR ps_cur(p_customer_trx_id NUMBER) IS
2924: SELECT terms_sequence_number,payment_schedule_id , due_date , dispute_date , amount_in_dispute , amount_due_remaining
2925: FROM ar_payment_schedules ps
2926: WHERE ps.customer_trx_id = p_customer_trx_id
2927: AND NVL(ps.amount_in_dispute,0) <> 0 /*12998583-M1*/
2928: ORDER BY terms_sequence_number desc;
2929: