[Home] [Help]
180: SELECT ( NVL( SUM(amount_line_items_original), 0)
181: -
182: NVL( SUM(amount_due_remaining), 0))
183: INTO l_invoiced_amount
184: FROM ar_payment_schedules_all
185: WHERE customer_trx_id = p_customer_trx_id;
186:
187:
188: /*------------------------------------------------------------+