APPS.LNS_FEE_ENGINE dependencies on LNS_LOAN_HEADERS

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 1959: from lns_loan_headers

1955: l_phase varchar2(30);
1956:
1957: cursor c_phase(p_loan_id number) is
1958: select nvl(current_phase, 'TERM')
1959: from lns_loan_headers
1960: where loan_id = p_loan_id;
1961:
1962: cursor c_precision (p_loan_id number)
1963: is

Line 1965: FROM lns_loan_headers lnh

1961:
1962: cursor c_precision (p_loan_id number)
1963: is
1964: SELECT fndc.precision
1965: FROM lns_loan_headers lnh
1966: ,fnd_currencies fndc
1967: WHERE lnh.loan_id = p_loan_id
1968: and lnh.loan_currency = fndc.currency_code;
1969: begin

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');

Line 3059: from lns_loan_headers

3055: l_loan_id number;
3056:
3057: cursor c_borrower_loans(p_borrower_id number) is
3058: select loan_id
3059: from lns_loan_headers
3060: where loan_status in ('ACTIVE', 'DELINQUENT', 'DEFAULT')
3061: and primary_borrower_id = p_borrower_id;
3062:
3063: cursor c_all_active_loans is

Line 3065: from lns_loan_headers

3061: and primary_borrower_id = p_borrower_id;
3062:
3063: cursor c_all_active_loans is
3064: select loan_id
3065: from lns_loan_headers
3066: where loan_status in ('ACTIVE', 'DELINQUENT', 'DEFAULT');
3067:
3068: BEGIN
3069: