APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
Line 1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai
1093: WHERE aip.invoice_id = p_invoice_id;
1094:
1095: SELECT nvl(SUM(aid.amount),0)
1096: INTO l_prepay_amt 1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai 1098: WHERE ail.invoice_id=aid.invoice_id
1099: AND ail.invoice_id=ai.invoice_id
1100: AND ail.line_number=aid.invoice_line_number
1101: AND ai.invoice_id=p_invoice_id