[Home] [Help]
1743: || Parameter: loan_id
1744: ||
1745: || Return value: current annual rate for the loan
1746: ||
1747: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADERS_ALL
1748: ||
1749: || Target Tables: NA
1750: ||
1751: || MODIFICATION HISTORY
1759: l_last_installment number;
1760:
1761: cursor c_activeRate(p_loan_id number, p_last_installment number) is
1762: select current_interest_rate
1763: from lns_rate_schedules rs
1764: ,lns_terms t
1765: ,lns_loan_headers_All lnh
1766: where lnh.loan_id = p_loan_id
1767: and lnh.loan_id = t.loan_id