APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 1323: from LNS_LOAN_HEADERS_ALL loan

1319: where CR.cash_receipt_id = p_recpt_id;
1320:
1321: Cursor getLoanCurrencyConversion(p_loanId number) is
1322: select loan.loan_currency LOAN_CURRENCY_CODE
1323: from LNS_LOAN_HEADERS_ALL loan
1324: where loan.loan_id = p_loanId;
1325:
1326: --receipt_currency_code varchar2(3);
1327: --loan_currency_code varchar2(3);

Line 1453: lns_loan_headers_all loan

1449:
1450: CURSOR precision_cur(P_LOAN_ID number) IS
1451: select curr.precision
1452: from fnd_currencies curr,
1453: lns_loan_headers_all loan
1454: where loan.loan_id = P_LOAN_ID and
1455: curr.currency_code = loan.loan_currency;
1456:
1457: cursor c_loanInfo(p_loan_id number) is

Line 1848: from lns_loan_headers_all

1844: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
1845:
1846: CURSOR loan_details_cur(P_LOAN_ID number) IS
1847: select LOAN_STATUS
1848: from lns_loan_headers_all
1849: where loan_id = P_LOAN_ID;
1850:
1851: begin
1852:

Line 2090: from lns_loan_headers_all

2086: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
2087:
2088: CURSOR loan_details_cur(P_LOAN_ID number) IS
2089: select LOAN_STATUS
2090: from lns_loan_headers_all
2091: where loan_id = P_LOAN_ID;
2092:
2093: CURSOR cancel_request_cur(P_LOAN_CANCELLATION_ID number) IS
2094: select LOAN_ID,

Line 2328: lns_loan_headers_all loan

2324:
2325: CURSOR precision_cur(P_LOAN_ID number) IS
2326: select curr.precision
2327: from fnd_currencies curr,
2328: lns_loan_headers_all loan
2329: where loan.loan_id = P_LOAN_ID and
2330: curr.currency_code = loan.loan_currency;
2331:
2332: CURSOR loan_version_cur(P_LOAN_ID number) IS

Line 2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

2563:
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2565:
2566: IF l_return_status = 'S' THEN
2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
2568: ELSE
2569: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2570: FND_MSG_PUB.Add;
2571: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

3124:
3125: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3126:
3127: IF l_return_status = 'S' THEN
3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3129: ELSE
3130: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3131: FND_MSG_PUB.Add;
3132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

3251:
3252: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3253:
3254: IF l_return_status = 'S' THEN
3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3256: ELSE
3257: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3258: FND_MSG_PUB.Add;
3259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3427: LNS_LOAN_HEADERS_ALL loan,

3423: CURSOR get_psa_cur(P_LOAN_ID number) IS
3424: SELECT psa.payment_schedule_id,
3425: am.AMORTIZATION_SCHEDULE_ID
3426: FROM ar_payment_schedules_all psa,
3427: LNS_LOAN_HEADERS_ALL loan,
3428: lns_amortization_scheds am
3429: WHERE loan.loan_id = am.loan_id and
3430: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and
3431: am.PAYMENT_NUMBER = loan.LAST_PAYMENT_NUMBER and

Line 3437: from lns_loan_headers_all

3433: psa.CUSTOMER_TRX_ID = am.principal_trx_id;
3434:
3435: CURSOR get_loan_number(P_LOAN_ID number) IS
3436: select loan_number
3437: from lns_loan_headers_all
3438: where loan_id = P_LOAN_ID;
3439:
3440: begin
3441: