DBA Data[Home] [Help]

APPS.LNS_OCM_ADP_PUB dependencies on LNS_RATE_SCHEDULES

Line 238: l_initial_interest_rate lns_rate_schedules.current_interest_rate%TYPE ;

234: FUNCTION initial_intrest_rate (x_resultout OUT NOCOPY VARCHAR2,
235: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
236: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
237:
238: l_initial_interest_rate lns_rate_schedules.current_interest_rate%TYPE ;
239:
240:
241: BEGIN
242:

Line 247: FROM lns_rate_schedules lrs,

243: x_resultout := FND_API.G_RET_STS_SUCCESS;
244: BEGIN
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