APPS.AP_TP_STMT_PKG dependencies on AP_CHECKS

Line 243: ,ap_checks ac

239: UNION ALL
240: SELECT 'P' transaction_type
241: ,SUM(NVL(aip.amount * NVL(aip.exchange_rate,1),0)) accounted_amount
242: FROM ap_invoice_payments aip
243: ,ap_checks ac
244: WHERE aip.check_id = ac.check_id
245: AND ac.vendor_id = p_in_vendor_id
246: AND ac.vendor_site_id = p_in_vendor_site_id
247: -- AND ac.check_date < TO_DATE(P_FROM_DOC_DATE,'RRRR/MM/DD HH24:MI:SS') Bug 14724500