APPS.LNS_FIN_UTILS dependencies on LNS_LOAN_HEADERS_ALL

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 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 1313: from lns_loan_headers_all

1309: l_phase varchar2(30);
1310:
1311: cursor c_phase (p_loan_id NUMBER) is
1312: select nvl(CURRENT_PHASE, 'TERM')
1313: from lns_loan_headers_all
1314: where loan_id = p_loan_id;
1315:
1316: begin
1317:

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

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

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

Line 2610: FROM lns_disb_headers dh, lns_loan_headers_all lhdr

2606: ,payment_request_date
2607: ,(select max(disbursement_date) from lns_disb_lines
2608: where disb_header_id = c_disb_hdr_id) disbursement_date
2609: ,dh.phase
2610: FROM lns_disb_headers dh, lns_loan_headers_all lhdr
2611: WHERE dh.disb_header_id = c_disb_hdr_id
2612: AND lhdr.loan_id = dh.loan_id;
2613:
2614: begin