3233: AND DECODE(AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE),
3234: 'NEVER APPROVED','Y',
3235: 'UNAPPROVED','Y',
3236: 'NEEDS REAPPROVAL',DECODE((SELECT COUNT(*) 3237: FROM DUAL 3238: WHERE NOT EXISTS (SELECT 1
3239: FROM AP_HOLDS AH
3240: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
3241: OR