DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on AR_PAYMENT_SCHEDULES

Line 1382: FROM ar_payment_schedules ps

1378: sum(ps.tax_original),
1379: sum(ps.freight_original),
1380: sum(ps.amount_due_original),
1381: ps.invoice_currency_code
1382: FROM ar_payment_schedules ps
1383: WHERE ps.customer_trx_id = p_customer_trx_id
1384: GROUP BY ps.invoice_currency_code ;
1385:
1386: BEGIN

Line 3531: FROM ar_payment_schedules ps

3527: /*4432212 */
3528:
3529: CURSOR ps_cur(p_customer_trx_id NUMBER) IS
3530: SELECT payment_schedule_id, due_date, amount_in_dispute, dispute_date
3531: FROM ar_payment_schedules ps
3532: WHERE ps.customer_trx_id = p_customer_trx_id;
3533:
3534:
3535: BEGIN