APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_LINES_ALL

Line 251: FROM AP_Invoice_Lines_ALL AIL,

247: AIL.Org_ID,
248: AID.Accounting_Date,
249: -- 6718967
250: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
251: FROM AP_Invoice_Lines_ALL AIL,
252: AP_Invoice_Distributions_All AID
253: WHERE AIL.Invoice_ID = p_invoice_id
254: AND AIL.Line_Type_Lookup_Code = 'PREPAY'
255: AND AIL.Invoice_ID = AID.Invoice_ID