APPS.LNS_IMPORT_LOAN_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 1253: UPDATE lns_amortization_scheds

1249: logmessage(fnd_log.level_unexpected, 'Bill ' || P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER || ' created successfully');
1250:
1251: if P_PAY_HIST_TBL(l_count).SOURCE = 'SCHEDULED' then
1252:
1253: UPDATE lns_amortization_scheds
1254: SET parent_amortization_id = NULL,
1255: REAMORTIZE_TO_INSTALLMENT = -1 -- marking this record as IMPORTED (-1); for original installments this field is always null
1256: WHERE amortization_schedule_id =
1257: (SELECT last_amortization_id

Line 1260: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');

1256: WHERE amortization_schedule_id =
1257: (SELECT last_amortization_id
1258: FROM lns_loan_headers_all
1259: WHERE loan_id = l_loan_id);
1260: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1261:
1262: else
1263:
1264: UPDATE lns_amortization_scheds

Line 1264: UPDATE lns_amortization_scheds

1260: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1261:
1262: else
1263:
1264: UPDATE lns_amortization_scheds
1265: SET REAMORTIZE_TO_INSTALLMENT = -1 -- marking this record as IMPORTED (-1); for original installments this field is always null
1266: WHERE amortization_schedule_id =
1267: (SELECT last_amortization_id
1268: FROM lns_loan_headers_all

Line 1270: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');

1266: WHERE amortization_schedule_id =
1267: (SELECT last_amortization_id
1268: FROM lns_loan_headers_all
1269: WHERE loan_id = l_loan_id);
1270: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1271:
1272: end if;
1273:
1274: l_paid_total := P_PAY_HIST_TBL(l_count).PAID_PRIN + P_PAY_HIST_TBL(l_count).PAID_INT + P_PAY_HIST_TBL(l_count).PAID_FEE;

Line 1322: FROM lns_amortization_scheds

1318: fee_trx_id
1319: INTO l_principal_trx_id,
1320: l_interest_trx_id,
1321: l_fee_trx_id
1322: FROM lns_amortization_scheds
1323: WHERE amortization_schedule_id =
1324: (SELECT last_amortization_id
1325: FROM lns_loan_headers_all
1326: WHERE loan_id = l_loan_id);