eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_FIN_UTILS dependencies on LNS_TERMS

Line 1199: FROM lns_loan_headers_all h, lns_terms t

1195: CURSOR c_payment_info(p_Loan_id NUMBER) IS
1196: SELECT
1197: t.loan_payment_frequency
1198: ,t.first_payment_date
1199: FROM lns_loan_headers_all h, lns_terms t
1200: WHERE h.loan_id = p_loan_id AND
1201: h.loan_id = t.loan_id;
1202:
1203: l_payment_frequency varchar2(30);

Line 1234: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1230: || Parameter: p_loan_id => loan_id
1231: ||
1232: || Return value: last number of installments
1233: ||
1234: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1235: ||
1236: || Target Tables: NA
1237: ||
1238: || MODIFICATION HISTORY

Line 1265: FROM lns_loan_headers_all h, lns_terms t

1261: ,h.amortized_term
1262: ,h.amortized_term_period
1263: ,t.amortization_frequency
1264: ,t.loan_payment_frequency
1265: FROM lns_loan_headers_all h, lns_terms t
1266: WHERE h.loan_id = p_loan_id AND
1267: h.loan_id = t.loan_id;
1268:
1269: begin

Line 1350: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1346: || p_phase => phase of the loan
1347: ||
1348: || Return value: last number of installments
1349: ||
1350: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1351: ||
1352: || Target Tables: NA
1353: ||
1354: || MODIFICATION HISTORY

Line 1407: FROM lns_loan_headers_all h, lns_terms t

1403: ,trunc(nvl(t.prin_first_pay_date, t.first_payment_date))
1404: ,nvl(t.prin_payment_frequency, t.loan_payment_frequency)
1405: ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y')
1406: ,nvl(h.custom_payments_flag, 'N')
1407: FROM lns_loan_headers_all h, lns_terms t
1408: WHERE h.loan_id = p_loan_id AND
1409: h.loan_id = t.loan_id;
1410:
1411: cursor c_num_cust_instal (p_loan_id NUMBER) is

Line 1593: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1589: || pay_in_arrears TRUE if loan is paid in arrears, FALSE in advance
1590: ||
1591: || Return value: table of dates
1592: ||
1593: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1594: ||
1595: || Target Tables: NA
1596: ||
1597: || MODIFICATION HISTORY

Line 1723: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1719: || Parameters:
1720: ||
1721: || Return value: table of dates
1722: ||
1723: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1724: ||
1725: || Target Tables: NA
1726: ||
1727: || KNOWN ISSUES

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 2123: ,lns_terms t

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
2127: and t.term_id = rs.term_id

Line 2273: FROM lns_loan_headers_all h, lns_terms t

2269: ,trunc(nvl(t.prin_first_pay_date, t.first_payment_date))
2270: ,nvl(t.prin_payment_frequency, t.loan_payment_frequency)
2271: ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y')
2272: ,nvl(h.custom_payments_flag, 'N')
2273: FROM lns_loan_headers_all h, lns_terms t
2274: WHERE h.loan_id = p_loan_id AND
2275: h.loan_id = t.loan_id;
2276:
2277: begin

Line 2416: FROM lns_loan_headers_all h, lns_terms t

2412: ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date),
2413: 'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date))
2414: ,nvl(t.PAYMENT_CALC_METHOD, 'EQUAL_PAYMENT')
2415: ,nvl(h.custom_payments_flag, 'N')
2416: FROM lns_loan_headers_all h, lns_terms t
2417: WHERE h.loan_id = p_loan_id AND
2418: h.loan_id = t.loan_id;
2419:
2420: cursor c_num_cust_instal (p_loan_id NUMBER) is

Line 2520: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS

2516: || p_phase => phase of the loan
2517: ||
2518: || Return value: installment number
2519: ||
2520: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
2521: ||
2522: || Target Tables: NA
2523: ||
2524: || MODIFICATION HISTORY