What is the meaning of this query in qlik sense

[farzeenabbas]

NVL((
SELECT COUNT(INSTALL_MENT_AMOUNT) FROM XX_MG_BANK_LOAN_REPAYMENT
WHERE HEADER_ID = AA.HEADER_ID AND TO_DATE(MONTH_NAME) <= to_date( substr(:p_to_d_date,1,10),'YYYY/MM/DD')
AND NVL(INSTALL_MENT_AMOUNT,0) > 0
and paid = 1
),0)
)) as outstanding_amount

[Or]

This is not a Qlik query. This looks like Oracle SQL. You should chat with your local Oracle SQL developers.