DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 639: ap_invoice_payments_all aip

635:
636: SELECT DISTINCT ac.payment_type_flag
637: INTO l_payment_type_flag
638: FROM ap_checks_all ac,
639: ap_invoice_payments_all aip
640: WHERE ac.check_id = aip.check_id
641: AND aip.invoice_id = l_prepay_hist_rec.prepay_invoice_id
642: AND rownum < 2;
643:

Line 758: --FROM AP_Invoice_Payments_All AIP

754: --
755: -- commenting below for bug10183934
756: --SELECT count(*)
757: --INTO l_upg_inv_pmts
758: --FROM AP_Invoice_Payments_All AIP
759: --WHERE Invoice_ID = p_invoice_id
760: --AND EXISTS (SELECT 'Upg Payment'
761: -- FROM AP_Payment_History_All APH,
762: -- AP_System_Parameters_All ASP,