DBA Data[Home] [Help]

APPS.AP_TP_STMT_PKG dependencies on AP_CHECKS

Line 240: ,ap_checks ac

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')