DBA Data[Home] [Help]

APPS.LNS_FIN_UTILS dependencies on LNS_RATE_SCHEDULES

Line 2106: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADERS_ALL

2102: || Parameter: loan_id
2103: ||
2104: || Return value: current annual rate for the loan
2105: ||
2106: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADERS_ALL
2107: ||
2108: || Target Tables: NA
2109: ||
2110: || MODIFICATION HISTORY

Line 2122: from lns_rate_schedules rs

2118: l_last_installment number;
2119:
2120: cursor c_activeRate(p_loan_id number, p_last_installment number) is
2121: select current_interest_rate
2122: from lns_rate_schedules rs
2123: ,lns_terms t
2124: ,lns_loan_headers_All lnh
2125: where lnh.loan_id = p_loan_id
2126: and lnh.loan_id = t.loan_id