APPS.FV_IPAC dependencies on AR_PAYMENT_SCHEDULES

Line 163: ar_payment_schedules arp

159: rctl.customer_trx_line_id
160: FROM ra_customer_trx_lines rctl,
161: ra_cust_trx_line_gl_dist rgld,
162: fnd_user fu,
163: ar_payment_schedules arp
164: WHERE rgld.customer_trx_id = p_customer_trx_id
165: AND rgld.customer_trx_id = rctl.customer_trx_id(+)
166: AND rctl.customer_trx_line_id(+) = rgld.customer_trx_line_id
167: AND rctl.created_by = fu.user_id(+)

Line 1283: FROM ar_payment_schedules

1279: SELECT SUM(amount_due_original),
1280: SUM(NVL(amount_adjusted,0)+ NVL(amount_credited,0)+ NVL(amount_due_remaining,0) + NVL(amount_applied,0))
1281: INTO v_original_amount,
1282: v_paid_amount
1283: FROM ar_payment_schedules
1284: WHERE customer_trx_id = trx_select_rec.customer_trx_id
1285: AND org_id = v_org_id;
1286: IF v_original_amount < v_paid_amount THEN
1287: trx_exception_flag := 'Y';