DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_HOLDS_ALL

Line 2434: FROM ap_holds_all H

2430: or p_pay_group_option = 'ALL')
2431: AND ((p_zero_inv_allowed = 'N' AND ps.amount_remaining <> 0) OR
2432: p_zero_inv_allowed = 'Y')
2433: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2434: FROM ap_holds_all H
2435: WHERE H.invoice_id = inv.invoice_id
2436: AND H.release_lookup_code is null)
2437: AND NOT EXISTS (SELECT 'Invoice is not fully approved'
2438: FROM ap_invoice_distributions_all D2