APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 491: From ap_payment_schedules aps,

487: ap_awt_tax_rates atr,
488: (Select count(distinct(aps.invoice_id)) inv_count,
489: api.vendor_id,
490: api.vendor_site_id
491: From ap_payment_schedules aps,
492: ap_invoices api
493: Where aps.amount_remaining > 0
494: And api.invoice_id = aps.invoice_id
495: Group by api.vendor_id, api.vendor_site_id) inv