APPS.LNS_IMPORT_LOAN_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 1145: FROM lns_loan_headers_all

1141:
1142: logmessage(fnd_log.LEVEL_STATEMENT, 'Updating Loan object...');
1143: SELECT object_version_number, loan_number
1144: INTO l_version_number, l_loan_number
1145: FROM lns_loan_headers_all
1146: WHERE loan_id = l_loan_id;
1147:
1148: l_loan_header_rec.loan_id := l_loan_id;
1149: l_loan_header_rec.LOAN_APPROVAL_DATE := P_Loan_Details_Rec.loan_approval_date;

Line 1258: FROM lns_loan_headers_all

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
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

Line 1268: FROM lns_loan_headers_all

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
1269: WHERE loan_id = l_loan_id);
1270: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1271:
1272: end if;

Line 1325: FROM lns_loan_headers_all

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);
1327:
1328: -- applying cash receipt
1329: IF(P_PAY_HIST_TBL(l_count).BILLED_PRIN > 0 AND