DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_CHECKS_PKG

Line 5478: AND ap_checks_pkg.get_posting_status(apc.check_id) IN ('Y','P')

5474: AND api.invoice_type_lookup_code IN ( 'CREDIT','DEBIT')
5475: AND apc.payment_type_flag = 'R'
5476: AND apip.posted_flag = 'Y'
5477: AND reversal_inv_pmt_id IS NULL
5478: AND ap_checks_pkg.get_posting_status(apc.check_id) IN ('Y','P')
5479: AND TRUNC(apc.check_date) BETWEEN TRUNC(l_gl_start_date) AND TRUNC(l_gl_end_date)
5480: AND NOT EXISTS
5481: ( SELECT 1 FROM fv_refunds_voids_all
5482: WHERE invoice_payment_id = apip.invoice_payment_id)