APPS.LNS_INDEX_RATES_PUB dependencies on LNS_RATE_SCHEDULES

Line 357: FROM lns_rate_schedules

353: index_rate,
354: spread,
355: CURRENT_INTEREST_RATE,
356: INTEREST_ONLY_FLAG
357: FROM lns_rate_schedules
358: WHERE end_date_active IS NULL
359: AND term_id = termId
360: AND PHASE = p_phase
361: order by begin_installment_number;

Line 759: update lns_rate_schedules

755: for k in 1..l_merged_rates_tbl.count loop
756:
757: if l_merged_rates_tbl(k).ACTION = 'UPDATE' then
758:
759: update lns_rate_schedules
760: set index_rate = l_merged_rates_tbl(k).INDEX_RATE
761: ,current_interest_rate = l_merged_rates_tbl(k).CURRENT_INTEREST_RATE
762: ,end_installment_number = l_merged_rates_tbl(k).END_INSTALLMENT_NUMBER
763: ,last_update_date = sysdate

Line 771: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_merged_rates_tbl(k).RATE_ID from dual;

767: where rate_id = l_merged_rates_tbl(k).RATE_ID;
768:
769: elsif l_merged_rates_tbl(k).ACTION = 'INSERT' then
770:
771: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_merged_rates_tbl(k).RATE_ID from dual;
772:
773: insert into lns_rate_schedules(
774: RATE_ID
775: ,TERM_ID

Line 773: insert into lns_rate_schedules(

769: elsif l_merged_rates_tbl(k).ACTION = 'INSERT' then
770:
771: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_merged_rates_tbl(k).RATE_ID from dual;
772:
773: insert into lns_rate_schedules(
774: RATE_ID
775: ,TERM_ID
776: ,INDEX_RATE
777: ,SPREAD