DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 174: FROM AP_Payment_History_All APH,

170: APH.Charges_Bank_Amount,
171: APH.Rev_Pmt_Hist_ID,
172: APH.Related_Event_ID,
173: APH.Invoice_Adjustment_Event_ID
174: FROM AP_Payment_History_All APH,
175: AP_Invoice_Payments_All AIP
176: WHERE AIP.Invoice_ID = P_Invoice_ID
177: AND AIP.Check_ID = APH.Check_ID
178: AND APH.Transaction_Type = P_Transaction_Type

Line 181: FROM AP_Payment_History_All APH1

177: AND AIP.Check_ID = APH.Check_ID
178: AND APH.Transaction_Type = P_Transaction_Type
179: AND NVL(AIP.Reversal_Flag, 'N') <> 'Y'
180: AND NOT EXISTS (SELECT 'Reversal Exists'
181: FROM AP_Payment_History_All APH1
182: WHERE APH1.Rev_Pmt_Hist_ID = APH.Payment_History_ID
183: AND APH1.Check_ID = APH.Check_ID);
184:
185: