APPS.LNS_EXT_LOAN_PUB dependencies on LNS_RATE_SCHEDULES

Line 904: from lns_rate_schedules

900: END_INSTALLMENT_NUMBER,
901: INDEX_RATE,
902: SPREAD,
903: INTEREST_ONLY_FLAG
904: from lns_rate_schedules
905: where term_id = p_term_id and
906: END_DATE_ACTIVE is null and
907: phase = 'TERM'
908: 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 1057: (LNS_RATE_SCHEDULES_S.nextval

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

Line 1085: update lns_rate_schedules

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

Line 1096: delete from lns_rate_schedules

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

Line 1435: from LNS_RATE_SCHEDULES

1431:
1432: -- query max installment number
1433: CURSOR rate_sched_cur(P_TERM_ID number) IS
1434: select max(end_installment_number)
1435: from LNS_RATE_SCHEDULES
1436: where term_id = P_TERM_ID and
1437: phase = 'TERM' and
1438: trunc(nvl(END_DATE_ACTIVE,(sysdate+1))) > trunc(sysdate);
1439: