DBA Data[Home] [Help]

APPS.FV_THIRD_PARTY_REMIT_PKG dependencies on AP_INVOICE_PAYMENTS

Line 437: FROM ap_checks apc, ap_invoice_payments apip, ap_invoices api

433:
434: CURSOR l_checks_invoices_cur IS
435: SELECT apc.check_number, apc.check_date, apc.amount,
436: invoice_num, invoice_amount, discount_amount_taken
437: FROM ap_checks apc, ap_invoice_payments apip, ap_invoices api
438: WHERE apc.bank_account_id = l_bank_account_id
439: AND apc.checkrun_name = l_checkrun_name
440: AND apc.check_number = l_check_num_fvtpp
441: AND apc.vendor_id = l_third_party_agent_id