DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 36: FROM AP_Invoice_Payments_All AIP

32: AIP.Exchange_Date,
33: AIP.Exchange_Rate,
34: NVL(AIP.Reversal_Flag,'N'),
35: AIP.Reversal_Inv_Pmt_ID
36: FROM AP_Invoice_Payments_All AIP
37: WHERE Accounting_Event_ID = P_Event_ID
38: AND AIP.Invoice_ID = DECODE(P_Invoice_ID, NULL, AIP.Invoice_ID,
39: P_Invoice_ID);
40:

Line 60: FROM AP_Invoice_Payments_All AIP

56: AIP.Exchange_Date,
57: AIP.Exchange_Rate,
58: NVL(AIP.Reversal_Flag,'N'),
59: AIP.Reversal_Inv_Pmt_ID
60: FROM AP_Invoice_Payments_All AIP
61: WHERE AIP.Check_ID = P_Check_ID
62: AND NVL(AIP.Reversal_Flag, 'N') <> 'Y' --bug 9072782, uncomment the change done in bug 7029334
63: AND AIP.Accounting_Event_ID NOT IN
64: (SELECT APH.Accounting_Event_ID