DBA Data[Home] [Help]

APPS.LNS_OCM_ADP_PUB dependencies on LNS_TERMS

Line 249: lns_terms lt

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

Line 727: FROM lns_terms lt , lns_loan_headers_all llh

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