Query to find the Never Validated Status for AP Done in Sona

SELECT  invoice_num,
              invoice_date,
              invoice_type_lookup_code
FROM     ap_invoices_all
WHERE  org_id =246
AND         AP_INVOICES_UTILITY_PKG.get_approval_status
             (invoice_id,
              invoice_amount,
              payment_status_flag,
              invoice_type_lookup_code) = 'NEVER APPROVED'
AND       invoice_date  BETWEEN  '01-AUG-2011' AND '30-SEP-2011'