APPS.ARP_CMREQ_WF dependencies on AR_PAYMENT_SCHEDULES

Line 525: from ar_payment_schedules ps

521: sum(ps.freight_original), sum(ps.amount_due_original),
522: ps.invoice_currency_code
523: into p_original_line_amount , p_original_tax_amount,
524: p_original_freight_amount, p_original_total, p_currency_code
525: from ar_payment_schedules ps
526: where ps.customer_trx_id = p_customer_trx_id
527: group by ps.invoice_currency_code ;
528:
529: exception

Line 2875: FROM ar_payment_schedules ps

2871: /*4220382 */
2872:
2873: CURSOR ps_cur(p_customer_trx_id NUMBER) IS
2874: SELECT payment_schedule_id, due_date, amount_in_dispute, dispute_date
2875: FROM ar_payment_schedules ps
2876: WHERE ps.customer_trx_id = p_customer_trx_id;
2877:
2878: begin
2879: SetOrgContext (p_item_key);