APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 944: from ap_invoice_distributions aid

940: INTO p_available_prepays
941: FROM ap_invoices I,
942: ap_suppliers PV
943: WHERE (select sum(aid.prepay_amount_remaining)
944: from ap_invoice_distributions aid
945: where aid.invoice_id = I.invoice_id
946: AND aid.line_type_lookup_code IN ('ITEM','TAX')
947: AND NVL(aid.reversal_flag,'N') <> 'Y'
948: ) > 0