APPS.LNS_BUS_EVENT_SUB_PVT dependencies on LNS_LOAN_HEADERS_ALL

Line 123: lns_loan_headers_all loan,

119: loan.org_id,
120: ams.AMORTIZATION_SCHEDULE_ID,
121: del.transaction_id
122: from
123: lns_loan_headers_all loan,
124: lns_amortization_scheds ams,
125: IEX_DELINQUENCIES_ALL del
126: where
127: del.request_id = P_REQUEST_ID and

Line 134: from LNS_LOAN_HEADERS_ALL

130:
131: -- getting loan version
132: CURSOR loan_version_cur(P_LOAN_ID number) IS
133: select OBJECT_VERSION_NUMBER
134: from LNS_LOAN_HEADERS_ALL
135: where LOAN_ID = P_LOAN_ID;
136:
137: BEGIN
138: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

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

237:
238: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
239:
240: IF l_return_status = 'S' THEN
241: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL with status ' || l_status);
242: ELSE
243: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
244: FND_MSG_PUB.Add;
245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));