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