694: 0, 1,
695: PS.GROSS_AMOUNT))))
696: FROM ap_payment_schedules_all PS,
697: ap_invoices_all ai,
698: ap_supplier_sites_all asi
699: WHERE ai.invoice_id = ps.invoice_id
700: AND ai.vendor_id = asi.vendor_id
701: AND ai.vendor_site_id = asi.vendor_site_id
702: AND ai.invoice_id = c_invoice_id