DBA Data[Home] [Help]

APPS.LNS_OCM_ADP_PUB dependencies on LNS_TERMS

Line 247: lns_terms lt

243: SELECT lrs.current_interest_rate
244: INTO l_initial_interest_rate
245: FROM lns_rate_schedules lrs,
246: lns_loan_headers_all llh ,
247: lns_terms lt
248: WHERE llh.loan_id = l_cr_loan_id
249: AND lt.loan_id = llh.loan_id
250: AND lrs.term_id = lt.term_id
251: AND lrs.begin_installment_number = 1

Line 725: FROM lns_terms lt , lns_loan_headers_all llh

721: x_resultout := FND_API.G_RET_STS_SUCCESS;
722: BEGIN
723: SELECT lt.delinquency_threshold_amount , llh.loan_currency
724: INTO l_deliquency_amount , l_loan_currency
725: FROM lns_terms lt , lns_loan_headers_all llh
726: WHERE llh.loan_id = l_cr_loan_id
727: AND lt.loan_id = llh.loan_id ;
728:
729: