DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_SPLITS

Line 3418: from LNS_LOAN_SPLITS spl,

3414: ,spl.SPREAD
3415: ,spl.INT_RATE
3416: ,spl.CUSTOM_SCHEDULE
3417: ,party. party_name
3418: from LNS_LOAN_SPLITS spl,
3419: HZ_PARTIES party
3420: where spl.LOAN_SPLIT_ID = p_LOAN_SPLIT_ID and
3421: party.party_id = spl.PRIMARY_BORROWER_ID;
3422:

Line 3765: update LNS_LOAN_SPLITS set

3761: end if;
3762:
3763: -- update split record
3764: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3765: update LNS_LOAN_SPLITS set
3766: NEW_AM_SCHED_ID = l_new_am_sched_id
3767: ,NEW_LOAN_ID = l_new_loan_id
3768: ,LOAN_NUMBER = l_LOAN_NUMBER
3769: ,STATUS = 'APPROVED'

Line 3868: update LNS_LOAN_SPLITS set

3864: -- ,p_action => 'REJECT');
3865:
3866: -- update split record
3867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3868: update LNS_LOAN_SPLITS set
3869: STATUS = 'REJECTED'
3870: ,APPR_REJECT_DATE = sysdate
3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3872: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1