APPS.LNS_FEE_ENGINE dependencies on LNS_LOAN_HEADERS_ALL

Line 158: from lns_loan_headers_all

154: and h.loan_id = p_loan_id;
155: --
156: cursor c_origLoanAmt(p_loan_id number) is
157: select requested_amount
158: from lns_loan_headers_all
159: where loan_id = p_loan_id;
160:
161: cursor c_lastPaymentNumber(p_loan_id number) is
162: select nvl(last_payment_number, 0)

Line 163: from lns_loan_headers_all

159: where loan_id = p_loan_id;
160:
161: cursor c_lastPaymentNumber(p_loan_id number) is
162: select nvl(last_payment_number, 0)
163: from lns_loan_headers_all
164: where loan_id = p_loan_id;
165:
166:
167: begin

Line 960: from lns_loan_headers_all

956:
957: -- fee basis for originalLoanAmount
958: cursor c_origLoanAmt(p_loan_id number) is
959: select requested_amount
960: from lns_loan_headers_all
961: where loan_id = p_loan_id;
962:
963: cursor c_disbAmount(p_disb_header_id number) is
964: select header_amount

Line 1229: FROM lns_loan_headers_all lnh

1225:
1226: cursor c_precision (p_loan_id number)
1227: is
1228: SELECT fndc.precision
1229: FROM lns_loan_headers_all lnh
1230: ,fnd_currencies fndc
1231: WHERE lnh.loan_id = p_loan_id
1232: and lnh.loan_currency = fndc.currency_code;
1233:

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

1997: ,x_msg_data => l_msg_data
1998: ,x_return_status => l_return_status
1999: ,p_col_id => p_loan_id
2000: ,p_col_name => 'LOAN_ID'
2001: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2002:
2003: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2005: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 2179: from lns_loan_headers_all

2175: i number;
2176:
2177: cursor c_phase(p_loan_id number) is
2178: select nvl(current_phase, 'TERM')
2179: from lns_loan_headers_all
2180: where loan_id = p_loan_id;
2181:
2182: l_phase varchar2(30);
2183:

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

2207: ,x_msg_data => l_msg_data
2208: ,x_return_status => l_return_status
2209: ,p_col_id => p_loan_id
2210: ,p_col_name => 'LOAN_ID'
2211: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2212:
2213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

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

2626: ,x_msg_data => l_msg_data
2627: ,x_return_status => l_return_status
2628: ,p_col_id => p_loan_id
2629: ,p_col_name => 'LOAN_ID'
2630: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2631:
2632: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2633: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2634: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');