eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_HEADERS

Line 137: from lns_loan_headers

133: where cash_receipt_id = p_cash_receipt_id;
134:
135: cursor c_loans_obj_vers(p_loan_id number) is
136: select OBJECT_VERSION_NUMBER
137: from lns_loan_headers
138: where loan_id = p_loan_id;
139:
140: CURSOR loans_cur (p_loan_id number) IS
141: select

Line 147: from LNS_LOAN_HEADERS head

143: ,nvl(head.exchange_rate, 1)
144: ,head.exchange_date
145: ,head.exchange_rate_type
146: ,head.current_phase
147: from LNS_LOAN_HEADERS head
148: where head.loan_id = p_loan_id and
149: head.loan_status in ('ACTIVE', 'DELINQUENT', 'DEFAULT');
150:
151: -- this cursor retrieves any applications to

Line 788: from lns_loan_headers

784: cursor c_loanInfo(p_loan_id number) is
785: select loan_number
786: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
787: ,current_phase
788: from lns_loan_headers
789: where loan_id = p_loan_id;
790:
791: cursor c_lastInterestAmount(p_loan_id number)
792: is

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 1349: from lns_loan_headers lnh

1345: select lnh.exchange_rate_type
1346: ,lnh.exchange_rate
1347: ,lnh.exchange_date
1348: ,lnh.loan_currency
1349: from lns_loan_headers lnh
1350: where loan_id = p_loan_id;
1351:
1352: cursor c_sob_currency is
1353: SELECT sb.currency_code

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

1459: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
1460: ,current_phase
1461: ,LOAN_CLASS_CODE
1462: ,FUNDED_AMOUNT
1463: from lns_loan_headers
1464: where loan_id = p_loan_id;
1465:
1466: cursor c_fees(p_loan_id number, p_phase varchar2, p_installment number) is
1467: select sched.fee_amount

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 2334: from LNS_LOAN_HEADERS

2330: curr.currency_code = loan.loan_currency;
2331:
2332: CURSOR loan_version_cur(P_LOAN_ID number) IS
2333: select OBJECT_VERSION_NUMBER
2334: from LNS_LOAN_HEADERS
2335: where LOAN_ID = P_LOAN_ID;
2336:
2337: begin
2338:

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 2660: from lns_loan_headers loan,

2656: loan.org_id,
2657: sys.CANCELLATION_REC_TRX_ID,
2658: loan.LOAN_CLASS_CODE,
2659: nvl(loan.DISABLE_BILLING_FLAG, 'N')
2660: from lns_loan_headers loan,
2661: LNS_SYSTEM_OPTIONS sys,
2662: LNS_LOAN_CANCELLATIONS cncl
2663: where cncl.LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID and
2664: cncl.LOAN_ID = loan.LOAN_ID and

Line 2687: from LNS_LOAN_HEADERS

2683: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
2684:
2685: CURSOR loan_version_cur(P_LOAN_ID number) IS
2686: select OBJECT_VERSION_NUMBER
2687: from LNS_LOAN_HEADERS
2688: where LOAN_ID = P_LOAN_ID;
2689:
2690: CURSOR new_invoices_cur(P_LOAN_ID number) IS
2691: select ps.customer_trx_id

Line 2696: from lns_loan_headers loan

2692: ,ps.payment_schedule_id
2693: ,decode(ps.customer_trx_id, am.principal_trx_Id, 'PRIN', am.interest_trx_id, 'INT', am.fee_trx_id, 'FEE')
2694: ,ps.trx_date
2695: ,ps.gl_date
2696: from lns_loan_headers loan
2697: ,lns_amortization_scheds am
2698: ,ar_payment_schedules ps
2699: where loan.loan_id = P_LOAN_ID and
2700: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and

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 3186: from LNS_LOAN_HEADERS loan, LNS_LOAN_CANCELLATIONS cncl

3182: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
3183:
3184: CURSOR loan_version_cur(p_LOAN_CANCELLATION_ID number) IS
3185: select loan.LOAN_ID, loan.OBJECT_VERSION_NUMBER
3186: from LNS_LOAN_HEADERS loan, LNS_LOAN_CANCELLATIONS cncl
3187: where cncl.LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID and
3188: cncl.LOAN_ID = loan.LOAN_ID;
3189:
3190: begin

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: