DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on AR_PAYMENT_SCHEDULES

Line 1267: FROM ar_payment_schedules

1263: SELECT SUM(amount_due_original),
1264: SUM(NVL(amount_adjusted,0)+ NVL(amount_credited,0)+ NVL(amount_due_remaining,0) + NVL(amount_applied,0))
1265: INTO v_original_amount,
1266: v_paid_amount
1267: FROM ar_payment_schedules
1268: WHERE customer_trx_id = trx_select_rec.customer_trx_id
1269: AND org_id = v_org_id;
1270: IF v_original_amount < v_paid_amount THEN
1271: trx_exception_flag := 'Y';