DBA Data[Home] [Help]

APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1092: FROM ap_invoice_payments_all aip

1088: --Overpayment code
1089:
1090: SELECT nvl(SUM(aip.amount),0)
1091: INTO l_pay_amt
1092: FROM ap_invoice_payments_all aip
1093: WHERE aip.invoice_id = p_invoice_id;
1094:
1095: SELECT nvl(SUM(aid.amount),0)
1096: INTO l_prepay_amt