APPS.LNS_EXT_LOAN_PUB dependencies on LNS_TERMS

Line 890: lns_terms term

886: term.term_id,
887: nvl(loan.custom_payments_flag, 'N')
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 1433: lns_terms term

1429: nvl(term.prin_payment_frequency, term.loan_payment_frequency),
1430: decode(trunc(nvl(term.prin_first_pay_date, term.first_payment_date)) - trunc(loan.loan_start_date), 0, 'N', 'Y'),
1431: nvl(loan.custom_payments_flag, 'N')
1432: from lns_loan_headers_all loan,
1433: lns_terms term
1434: where loan.loan_id = P_LOAN_ID and
1435: loan.loan_id = term.loan_id;
1436:
1437: -- query max installment number