APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 970: from ap_invoice_distributions aid

966: INTO p_available_prepays
967: FROM ap_invoices I,
968: ap_suppliers PV
969: WHERE (select sum(aid.prepay_amount_remaining)
970: from ap_invoice_distributions aid
971: where aid.invoice_id = I.invoice_id
972: AND aid.line_type_lookup_code IN ('ITEM','TAX')
973: AND NVL(aid.reversal_flag,'N') <> 'Y'
974: ) > 0