APPS.LNS_BUS_EVENT_SUB_PVT dependencies on LNS_LOAN_HEADERS_ALL

Line 118: lns_loan_headers_all loan,

114: loan.org_id,
115: ams.AMORTIZATION_SCHEDULE_ID,
116: del.transaction_id
117: from
118: lns_loan_headers_all loan,
119: lns_amortization_scheds ams,
120: IEX_DELINQUENCIES_ALL del
121: where
122: del.request_id = P_REQUEST_ID and

Line 262: from LNS_LOAN_HEADERS_ALL

258:
259: -- getting loan version
260: CURSOR loan_version_cur(P_LOAN_ID number) IS
261: select OBJECT_VERSION_NUMBER, LOAN_STATUS
262: from LNS_LOAN_HEADERS_ALL
263: where LOAN_ID = P_LOAN_ID;
264:
265: BEGIN
266:

Line 403: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL with status ' || l_status);

399:
400: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
401:
402: IF l_return_status = 'S' THEN
403: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL with status ' || l_status);
404: ELSE
405: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
406: FND_MSG_PUB.Add;
407: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));