DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 199: FROM AP_Payment_History_All APH,

195: APH.Charges_Bank_Amount,
196: APH.Rev_Pmt_Hist_ID,
197: APH.Related_Event_ID,
198: APH.Invoice_Adjustment_Event_ID
199: FROM AP_Payment_History_All APH,
200: AP_Invoice_Payments_All AIP
201: WHERE AIP.Invoice_ID = P_Invoice_ID
202: AND AIP.Check_ID = APH.Check_ID
203: AND APH.Transaction_Type = P_Transaction_Type

Line 206: FROM AP_Payment_History_All APH1

202: AND AIP.Check_ID = APH.Check_ID
203: AND APH.Transaction_Type = P_Transaction_Type
204: AND NVL(AIP.Reversal_Flag, 'N') <> 'Y'
205: AND NOT EXISTS (SELECT 'Reversal Exists'
206: FROM AP_Payment_History_All APH1
207: WHERE APH1.Rev_Pmt_Hist_ID = APH.Payment_History_ID
208: AND APH1.Check_ID = APH.Check_ID);
209:
210: