APPS.LNS_CUSTOM_PUB dependencies on LNS_RATE_SCHEDULES

Line 1245: from lns_rate_schedules

1241:
1242: -- cursor to load rate schedule
1243: cursor c_rate_sched(p_term_id NUMBER) IS
1244: select RATE_ID, CURRENT_INTEREST_RATE, BEGIN_INSTALLMENT_NUMBER, END_INSTALLMENT_NUMBER
1245: from lns_rate_schedules
1246: where term_id = p_term_id and
1247: END_DATE_ACTIVE is null and
1248: nvl(PHASE, 'TERM') = 'TERM'
1249: order by END_INSTALLMENT_NUMBER desc;

Line 1273: update lns_rate_schedules

1269: if p_num_installments > l_END_INSTALLMENT then
1270:
1271: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || p_num_installments);
1272:
1273: update lns_rate_schedules
1274: set END_INSTALLMENT_NUMBER = p_num_installments
1275: where term_id = p_term_id and
1276: RATE_ID = l_RATE_ID;
1277:

Line 1284: update lns_rate_schedules

1280: elsif p_num_installments >= l_BEGIN_INSTALLMENT and p_num_installments <= l_END_INSTALLMENT then
1281:
1282: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || p_num_installments);
1283:
1284: update lns_rate_schedules
1285: set END_INSTALLMENT_NUMBER = p_num_installments
1286: where term_id = p_term_id and
1287: RATE_ID = l_RATE_ID;
1288:

Line 1295: delete from lns_rate_schedules

1291: elsif p_num_installments < l_BEGIN_INSTALLMENT then
1292:
1293: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleting this row');
1294:
1295: delete from lns_rate_schedules
1296: where term_id = p_term_id and
1297: RATE_ID = l_RATE_ID;
1298:
1299: end if;