DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 65: FROM AP_Payment_History_All APH

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

Line 92: FROM AP_Payment_History_All APH

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