SQL query to retrieve the canceled invoices amount as per the date for AP aging report.

((select 
                        sum(aia1.CANCELLED_AMOUNT) 
                        from 
                        ap_invoices_all aia1
                        where 1=1 
            and aia1.APPROVAL_STATUS = 'CANCELLED'
            and aia1.invoice_id = aia.invoice_id
            AND :as_of_date  < aia1.CANCELLED_DATE
            ),0)

-» I attempted to modify the previous query to retrieve canceled invoices that are unpaid, but I am not getting the desired output. Please provide a query that will give me the canceled invoices of unpaid. SQL query to retrieve the amount of the canceled invoice as per the date for the AP aging report.

Thank you

Vikas