7785: -- begin fix for bug 6724561
7786: -- cursor to get latest extended from installment - last billed installment from the last approved loan extension
7787: cursor c_ext_from_install(p_loan_id NUMBER) IS
7788: select LAST_BILLED_INSTALLMENT
7789: from LNS_LOAN_EXTENSIONS
7790: where loan_id = p_loan_id
7791: and STATUS = 'APPROVED'
7792: order by LOAN_EXT_ID desc;
7793: -- end fix for bug 6724561
7801: OLD_BALLOON_AMOUNT,
7802: OLD_AMORT_TERM,
7803: OLD_MATURITY_DATE,
7804: OLD_INSTALLMENTS
7805: from LNS_LOAN_EXTENSIONS
7806: where loan_id = p_loan_id
7807: and STATUS = 'APPROVED'
7808: order by LOAN_EXT_ID;
7809: