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 59: FROM AP_Invoice_Payments_All AIP

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