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 1126: FROM lns_loan_headers_all h, lns_terms t

1122: CURSOR c_payment_info(p_Loan_id NUMBER) IS
1123: SELECT
1124: t.loan_payment_frequency
1125: ,t.first_payment_date
1126: FROM lns_loan_headers_all h, lns_terms t
1127: WHERE h.loan_id = p_loan_id AND
1128: h.loan_id = t.loan_id;
1129:
1130: l_payment_frequency varchar2(30);

Line 1160: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1156: || Parameter: p_loan_id => loan_id
1157: ||
1158: || Return value: last number of installments
1159: ||
1160: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1161: ||
1162: || Target Tables: NA
1163: ||
1164: || MODIFICATION HISTORY

Line 1190: FROM lns_loan_headers_all h, lns_terms t

1186: ,h.amortized_term
1187: ,h.amortized_term_period
1188: ,t.amortization_frequency
1189: ,t.loan_payment_frequency
1190: FROM lns_loan_headers_all h, lns_terms t
1191: WHERE h.loan_id = p_loan_id AND
1192: h.loan_id = t.loan_id;
1193:
1194: begin

Line 1242: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1238: || p_phase => phase of the loan
1239: ||
1240: || Return value: last number of installments
1241: ||
1242: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1243: ||
1244: || Target Tables: NA
1245: ||
1246: || MODIFICATION HISTORY

Line 1293: FROM lns_loan_headers_all h, lns_terms t

1289: ,trunc(nvl(t.prin_first_pay_date, t.first_payment_date))
1290: ,nvl(t.prin_payment_frequency, t.loan_payment_frequency)
1291: ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y')
1292: ,nvl(h.custom_payments_flag, 'N')
1293: FROM lns_loan_headers_all h, lns_terms t
1294: WHERE h.loan_id = p_loan_id AND
1295: h.loan_id = t.loan_id;
1296:
1297: cursor c_num_cust_instal (p_loan_id NUMBER) is

Line 1430: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1426: || pay_in_arrears TRUE if loan is paid in arrears, FALSE in advance
1427: ||
1428: || Return value: table of dates
1429: ||
1430: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1431: ||
1432: || Target Tables: NA
1433: ||
1434: || MODIFICATION HISTORY

Line 1515: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS

1511: || Parameters:
1512: ||
1513: || Return value: table of dates
1514: ||
1515: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS
1516: ||
1517: || Target Tables: NA
1518: ||
1519: || KNOWN ISSUES

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

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

Line 1764: ,lns_terms t

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