DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 64: FROM AP_Payment_History_All APH

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
64: FROM AP_Payment_History_All APH
65: WHERE APH.Check_ID = P_Check_ID
66: AND APH.Transaction_Type = 'PAYMENT CANCELLED'); --bug 7029334 'PAYMENT CANCELLATION'
67:
68: -- Cursor to get payment history information

Line 90: FROM AP_Payment_History_All APH

86: APH.Charges_Bank_Amount,
87: APH.Rev_Pmt_Hist_ID,
88: APH.Related_Event_ID,
89: APH.Invoice_Adjustment_Event_ID
90: FROM AP_Payment_History_All APH
91: WHERE APH.Accounting_Event_ID = P_Event_ID;
92:
93:
94: -- Cursor to get the invoice header information for the given