APPS.LNS_EXT_LOAN_PUB dependencies on LNS_RATE_SCHEDULES

Line 905: from lns_rate_schedules

901: INDEX_RATE,
902: SPREAD,
903: INTEREST_ONLY_FLAG,
904: FLOATING_FLAG
905: from lns_rate_schedules
906: where term_id = p_term_id and
907: END_DATE_ACTIVE is null and
908: phase = 'TERM'
909: order by END_INSTALLMENT_NUMBER desc;

Line 1028: update lns_rate_schedules

1024: then
1025:
1026: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || l_NEW_INSTALLMENTS);
1027:
1028: update lns_rate_schedules
1029: set END_INSTALLMENT_NUMBER = l_NEW_INSTALLMENTS
1030: where term_id = l_TERM_ID and
1031: RATE_ID = l_RATE_ID;
1032:

Line 1035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_RATE_SCHEDULES...');

1031: RATE_ID = l_RATE_ID;
1032:
1033: else
1034:
1035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_RATE_SCHEDULES...');
1036:
1037: insert into LNS_RATE_SCHEDULES
1038: (RATE_ID
1039: ,TERM_ID

Line 1037: insert into LNS_RATE_SCHEDULES

1033: else
1034:
1035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_RATE_SCHEDULES...');
1036:
1037: insert into LNS_RATE_SCHEDULES
1038: (RATE_ID
1039: ,TERM_ID
1040: ,INDEX_RATE
1041: ,SPREAD

Line 1058: (LNS_RATE_SCHEDULES_S.nextval

1054: ,INTEREST_ONLY_FLAG
1055: ,FLOATING_FLAG
1056: ,PHASE)
1057: VALUES
1058: (LNS_RATE_SCHEDULES_S.nextval
1059: ,l_TERM_ID
1060: ,l_EXT_RATE
1061: ,l_EXT_SPREAD
1062: ,(l_EXT_RATE+l_EXT_SPREAD)

Line 1087: update lns_rate_schedules

1083: elsif l_NEW_INSTALLMENTS >= l_BEGIN_INSTALLMENT and l_NEW_INSTALLMENTS <= l_END_INSTALLMENT then
1084:
1085: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating this row - set END_INSTALLMENT_NUMBER = ' || l_NEW_INSTALLMENTS);
1086:
1087: update lns_rate_schedules
1088: set END_INSTALLMENT_NUMBER = l_NEW_INSTALLMENTS
1089: where term_id = l_TERM_ID and
1090: RATE_ID = l_RATE_ID;
1091:

Line 1098: delete from lns_rate_schedules

1094: elsif l_NEW_INSTALLMENTS < l_BEGIN_INSTALLMENT then
1095:
1096: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting this row');
1097:
1098: delete from lns_rate_schedules
1099: where term_id = l_TERM_ID and
1100: RATE_ID = l_RATE_ID;
1101:
1102: end if;

Line 1440: from LNS_RATE_SCHEDULES

1436:
1437: -- query max installment number
1438: CURSOR rate_sched_cur(P_TERM_ID number) IS
1439: select max(end_installment_number)
1440: from LNS_RATE_SCHEDULES
1441: where term_id = P_TERM_ID and
1442: phase = 'TERM' and
1443: trunc(nvl(END_DATE_ACTIVE,(sysdate+1))) > trunc(sysdate);
1444: