APPS.LNS_FEE_ENGINE dependencies on LNS_LOAN_HEADERS_ALL

Line 166: from lns_loan_headers_all

162: and h.loan_id = p_loan_id;
163: --
164: cursor c_origLoanAmt(p_loan_id number) is
165: select requested_amount
166: from lns_loan_headers_all
167: where loan_id = p_loan_id;
168:
169: cursor c_lastPaymentNumber(p_loan_id number) is
170: select nvl(last_payment_number, 0)

Line 171: from lns_loan_headers_all

167: where loan_id = p_loan_id;
168:
169: cursor c_lastPaymentNumber(p_loan_id number) is
170: select nvl(last_payment_number, 0)
171: from lns_loan_headers_all
172: where loan_id = p_loan_id;
173:
174:
175: begin

Line 994: from lns_loan_headers_all

990:
991: -- fee basis for originalLoanAmount
992: cursor c_origLoanAmt(p_loan_id number) is
993: select requested_amount, nvl(current_phase, 'TERM')
994: from lns_loan_headers_all
995: where loan_id = p_loan_id;
996:
997: cursor c_disbAmount(p_disb_header_id number) is
998: select header_amount

Line 1175: from lns_loan_headers_all lh

1171:
1172: l_api_name := 'calculateFee';
1173:
1174: select lh.loan_status into l_loan_status
1175: from lns_loan_headers_all lh
1176: where lh.loan_id = P_LOAN_ID;
1177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_loan_status = ' || l_loan_status);
1178:
1179: if(l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') then

Line 1315: FROM lns_loan_headers_all lnh

1311:
1312: cursor c_precision (p_loan_id number)
1313: is
1314: SELECT fndc.precision
1315: FROM lns_loan_headers_all lnh
1316: ,fnd_currencies fndc
1317: WHERE lnh.loan_id = p_loan_id
1318: and lnh.loan_currency = fndc.currency_code;
1319:

Line 2329: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

2325: ,x_msg_data => l_msg_data
2326: ,x_return_status => l_return_status
2327: ,p_col_id => p_loan_id
2328: ,p_col_name => 'LOAN_ID'
2329: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2330:
2331: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2332: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2333: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 2520: from lns_loan_headers_all

2516: l_phase varchar2(30);
2517:
2518: cursor c_phase(p_loan_id number) is
2519: select nvl(current_phase, 'TERM')
2520: from lns_loan_headers_all
2521: where loan_id = p_loan_id;
2522:
2523: begin
2524:

Line 2550: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

2546: ,x_msg_data => l_msg_data
2547: ,x_return_status => l_return_status
2548: ,p_col_id => p_loan_id
2549: ,p_col_name => 'LOAN_ID'
2550: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2551:
2552: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2553: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2554: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 3076: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

3072: ,x_msg_data => l_msg_data
3073: ,x_return_status => l_return_status
3074: ,p_col_id => p_loan_id
3075: ,p_col_name => 'LOAN_ID'
3076: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
3077:
3078: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3079: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3080: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');