APPS.LNS_EXT_LOAN_PUB dependencies on LNS_TERMS

Line 890: lns_terms term

886: ext.EXT_TERM,
887: ext.EXT_TERM_PERIOD
888: from lns_loan_extensions ext,
889: lns_loan_headers_all loan,
890: lns_terms term
891: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID and
892: loan.LOAN_ID = ext.LOAN_ID and
893: term.loan_id = loan.LOAN_ID;
894:

Line 1428: lns_terms term

1424: nvl(term.prin_payment_frequency, term.loan_payment_frequency),
1425: decode(trunc(nvl(term.prin_first_pay_date, term.first_payment_date)) - trunc(loan.loan_start_date), 0, 'N', 'Y'),
1426: nvl(loan.custom_payments_flag, 'N')
1427: from lns_loan_headers_all loan,
1428: lns_terms term
1429: where loan.loan_id = P_LOAN_ID and
1430: loan.loan_id = term.loan_id;
1431:
1432: -- query max installment number