DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on AR_PAYMENT_SCHEDULES

Line 1885: l_ps_rec ar_payment_schedules%ROWTYPE;

1881: p_prorated_line IN NUMBER,
1882: p_prorated_tax IN NUMBER)
1883: IS
1884: l_adj_rec ar_adjustments%ROWTYPE;
1885: l_ps_rec ar_payment_schedules%ROWTYPE;
1886: l_orig_line_adj NUMBER := 0;
1887: l_orig_tax_adj NUMBER := 0;
1888: l_ps_update_needed BOOLEAN := TRUE;
1889: BEGIN

Line 2463: FROM ar_payment_schedules ps

2459: IF p_mode in ('LINE','TAX','INV')
2460: THEN
2461: SELECT sum(amount_due_remaining)
2462: INTO l_amt_due_remaining
2463: FROM ar_payment_schedules ps
2464: where ps.customer_trx_id = p_target_id
2465: group by ps.customer_trx_id;
2466:
2467: IF (PG_DEBUG in ('Y','C')) THEN