DBA Data[Home] [Help]

APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES_ALL

Line 212: FROM AP_INVOICE_LINES_ALL AIL

208: --Bug 6802813: Added new cursor to generate tax distributions
209: -- while navigating from 'All Distributions' button.
210: CURSOR c_tax_lines IS
211: SELECT 'Tax Lines not fully distributed'
212: FROM AP_INVOICE_LINES_ALL AIL
213: WHERE AIL.INVOICE_ID = P_INVOICE_ID
214: AND AIL.LINE_TYPE_LOOKUP_CODE = 'TAX'
215: AND AIL.amount <>
216: (SELECT nvl(sum(amount),0)