DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 507: AP_Prepay_History_All APH

503: -- Bug 7138115. Added additional join conditions to improve performance
504: SELECT SUM(APAD.Base_Amount)
505: INTO l_sum_prepay_base_amt
506: FROM AP_Prepay_App_Dists APAD,
507: AP_Prepay_History_All APH
508: WHERE ((APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
509: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
510: 'PREPAY APPL NONREC TAX'))
511: OR (APAD.AWT_Related_ID = l_inv_dist_rec.invoice_distribution_id