APPS.LNS_BUS_EVENT_SUB_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 117

        select ams.LOAN_ID,
            loan.loan_number,
            loan.org_id,
            ams.AMORTIZATION_SCHEDULE_ID,
            del.transaction_id
        from
            lns_loan_headers_all loan,
            lns_amortization_scheds ams,
            IEX_DELINQUENCIES_ALL del
        where
        	del.request_id = P_REQUEST_ID and
        	del.transaction_id in (ams.PRINCIPAL_TRX_ID, ams.INTEREST_TRX_ID, ams.FEE_TRX_ID) and
            ams.loan_id = loan.loan_id;

Line: 133

        select OBJECT_VERSION_NUMBER
        from LNS_LOAN_HEADERS_ALL
        where LOAN_ID = P_LOAN_ID;

Line: 147

    l_num_del_upd := p_event.GetValueForParameter('NOOFDELUPDATED');

Line: 152

    LogMessage(FND_LOG.LEVEL_STATEMENT, 'number of updated del: ' || l_num_del_upd);

Line: 231

            LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
                                            P_LOAN_HEADER_REC => l_loan_header_rec,
                                            P_INIT_MSG_LIST => FND_API.G_TRUE,
                                            X_RETURN_STATUS => l_return_status,
                                            X_MSG_COUNT => l_msg_count,
                                            X_MSG_DATA => l_msg_data);

Line: 241

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