DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_LINES

Line 1488: from lns_loan_lines lines,

1484: lines.REFERENCE_NUMBER,
1485: trx_type.name || ' - ' || trx_type_lkup.meaning,
1486: lines.REQUESTED_AMOUNT,
1487: lines.INSTALLMENT_NUMBER
1488: from lns_loan_lines lines,
1489: RA_CUSTOMER_TRX_ALL cust_trx,
1490: RA_CUST_TRX_TYPES trx_type,
1491: ar_lookups trx_type_lkup
1492: where lines.status = 'APPROVED'

Line 2782: update LNS_LOAN_LINES set

2778: END IF;
2779: else
2780: -- cancel all remaining pending orig receivables
2781: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rejecting all remaining pending orig receivables...');
2782: update LNS_LOAN_LINES set
2783: STATUS = 'REJECTED'
2784: ,LAST_UPDATE_DATE = sysdate
2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2786: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN