DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_CHECKS_PKG

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

5618: AND api.invoice_type_lookup_code IN ( 'CREDIT','DEBIT')
5619: AND apc.payment_type_flag = 'R'
5620: AND apip.posted_flag = 'Y'
5621: AND reversal_inv_pmt_id IS NULL
5622: AND ap_checks_pkg.get_posting_status(apc.check_id) IN ('Y','P')
5623: AND TRUNC(apc.check_date) BETWEEN TRUNC(l_gl_start_date) AND TRUNC(l_gl_end_date)
5624: AND NOT EXISTS
5625: ( SELECT 1 FROM fv_refunds_voids_all
5626: WHERE invoice_payment_id = apip.invoice_payment_id)