APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 762: FROM ap_invoice_distributions_all aid

758: l_debug_info := 'Get the total dist proration total';
759:
760: SELECT sum(aid.amount)
761: INTO l_dist_total
762: FROM ap_invoice_distributions_all aid
763: WHERE aid.invoice_id = x_corrected_invoice_id
764: AND aid.invoice_line_number = x_corrected_line_number
765: AND aid.line_type_lookup_code = 'ITEM' -- Bug 5597409. Restrict to 'ITEM' type only
766: AND aid.prepay_distribution_id IS NULL;