APPS.LNS_CUSTOM_PUB dependencies on LNS_RATE_SCHEDULES

Line 1404: from lns_rate_schedules

1400:
1401: -- cursor to load rate schedule
1402: cursor c_rate_sched(p_term_id NUMBER) IS
1403: select RATE_ID, CURRENT_INTEREST_RATE, BEGIN_INSTALLMENT_NUMBER, END_INSTALLMENT_NUMBER
1404: from lns_rate_schedules
1405: where term_id = p_term_id and
1406: END_DATE_ACTIVE is null and
1407: nvl(PHASE, 'TERM') = 'TERM'
1408: order by END_INSTALLMENT_NUMBER desc;

Line 1432: update lns_rate_schedules

1428: if p_num_installments > l_END_INSTALLMENT then
1429:
1430: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || p_num_installments);
1431:
1432: update lns_rate_schedules
1433: set END_INSTALLMENT_NUMBER = p_num_installments
1434: where term_id = p_term_id and
1435: RATE_ID = l_RATE_ID;
1436:

Line 1443: update lns_rate_schedules

1439: elsif p_num_installments >= l_BEGIN_INSTALLMENT and p_num_installments <= l_END_INSTALLMENT then
1440:
1441: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || p_num_installments);
1442:
1443: update lns_rate_schedules
1444: set END_INSTALLMENT_NUMBER = p_num_installments
1445: where term_id = p_term_id and
1446: RATE_ID = l_RATE_ID;
1447:

Line 1454: delete from lns_rate_schedules

1450: elsif p_num_installments < l_BEGIN_INSTALLMENT then
1451:
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleting this row');
1453:
1454: delete from lns_rate_schedules
1455: where term_id = p_term_id and
1456: RATE_ID = l_RATE_ID;
1457:
1458: end if;