APPS.LNS_FIN_UTILS dependencies on LNS_LOAN_HEADERS_ALL

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 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 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 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 1765: ,lns_loan_headers_All lnh

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
1769: and rs.end_installment_number >= p_last_installment