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.

APPS.LNS_FINANCIALS dependencies on LNS_AMORTIZATION_SCHEDS

Line 1225: -- then insert reamortization information into LNS_AMORTIZATION_SCHEDS

1221: -- Api body
1222: -- get the loan details
1223: -- compare the actual balance to the theoretical balance
1224: -- if they are inconsistent and reamorization flag is set
1225: -- then insert reamortization information into LNS_AMORTIZATION_SCHEDS
1226: /*
1227: if p_installment_number = 0 then
1228: i := p_installment_number + 1;
1229: else

Line 1353: from lns_amortization_scheds

1349: -- remove all reAmortize rows from amortization schedule
1350: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' removing previous reAmortize rows');
1351:
1352: delete
1353: from lns_amortization_scheds
1354: where loan_id = p_loan_id
1355: and reamortization_amount is not null
1356: and reamortize_from_installment is not null;
1357:

Line 1360: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id

1356: and reamortize_from_installment is not null;
1357:
1358: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' REAMORTIZE OVERPAY LOAN');
1359: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' insert record into amortizations');
1360: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id
1361: ,loan_id
1362: ,reamortization_amount
1363: ,reamortize_from_installment
1364: ,reamortize_to_installment

Line 1371: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL

1367: ,last_updated_by
1368: ,last_update_date
1369: ,object_version_number)
1370: values
1371: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL
1372: ,p_loan_id
1373: ,l_actual_balance
1374: ,p_installment_number
1375: ,null

Line 1387: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id

1383: /*
1384: elsif l_loan_details.reamortize_underpay = 'Y' and l_actual_balance > l_theoretical_balance then
1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' REAMORTIZE UNDERPAY LOAN');
1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' insert record into amortizations');
1387: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id
1388: ,loan_id
1389: ,reamortization_amount
1390: ,reamortize_from_installment
1391: ,reamortize_to_installment

Line 1398: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL

1394: ,last_updated_by
1395: ,last_update_date
1396: ,object_version_number)
1397: values
1398: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL
1399: ,p_loan_id
1400: ,l_actual_balance
1401: ,p_installment_number
1402: ,null

Line 2596: from LNS_AMORTIZATION_SCHEDS

2592:
2593: -- get first billed installment number
2594: cursor c_first_billed_instal(p_loan_id number) is
2595: select min(PAYMENT_NUMBER)
2596: from LNS_AMORTIZATION_SCHEDS
2597: where loan_id = p_loan_id
2598: and PAYMENT_NUMBER > 0
2599: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
2600: and PARENT_AMORTIZATION_ID is null

Line 3669: from lns_amortization_scheds

3665:
3666: -- get last billed payment info
3667: cursor c_get_last_payment(p_loan_id number, p_installment_number number) is
3668: select PRINCIPAL_AMOUNT
3669: from lns_amortization_scheds
3670: where loan_id = p_loan_id
3671: and PAYMENT_NUMBER > 0
3672: and PAYMENT_NUMBER <= p_installment_number
3673: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')

Line 3682: from LNS_AMORTIZATION_SCHEDS

3678:
3679: -- get first billed installment number
3680: cursor c_first_billed_instal(p_loan_id number) is
3681: select min(PAYMENT_NUMBER)
3682: from LNS_AMORTIZATION_SCHEDS
3683: where loan_id = p_loan_id
3684: and PAYMENT_NUMBER > 0
3685: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
3686: and PARENT_AMORTIZATION_ID is null

Line 4677: from lns_amortization_scheds

4673:
4674: -- get last billed payment info
4675: cursor c_get_last_payment(p_loan_id number, p_installment_number number) is
4676: select (PRINCIPAL_AMOUNT + INTEREST_AMOUNT)
4677: from lns_amortization_scheds
4678: where loan_id = p_loan_id
4679: and PAYMENT_NUMBER > 0
4680: and PAYMENT_NUMBER <= p_installment_number
4681: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')

Line 4690: from LNS_AMORTIZATION_SCHEDS

4686:
4687: -- get first billed installment number
4688: cursor c_first_billed_instal(p_loan_id number) is
4689: select min(PAYMENT_NUMBER)
4690: from LNS_AMORTIZATION_SCHEDS
4691: where loan_id = p_loan_id
4692: and PAYMENT_NUMBER > 0
4693: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
4694: and PARENT_AMORTIZATION_ID is null

Line 6751: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS

6747: || Parameter: loan_id
6748: ||
6749: || Return value: table of dates
6750: ||
6751: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS
6752: ||
6753: || Target Tables: NA
6754: ||
6755: || KNOWN ISSUES

Line 6873: -- this is temporary place on LNS_AMORTIZATION_SCHEDS

6869: AND rs.end_date_active is null;
6870: */
6871:
6872: -- get reamortization information
6873: -- this is temporary place on LNS_AMORTIZATION_SCHEDS
6874: -- we should move this to LNS_TERMS when we have terms realignment
6875: -- bug# 5664316 - we only store ONE reamortization row
6876: CURSOR c_reamortization(p_Loan_id NUMBER) IS
6877: SELECT nvl(reamortization_amount, 0)

Line 6881: lns_amortization_scheds amort1

6877: SELECT nvl(reamortization_amount, 0)
6878: ,nvl(reamortize_from_installment, 0)
6879: ,nvl(reamortize_to_installment, 0)
6880: FROM lns_loan_headers_all lnh,
6881: lns_amortization_scheds amort1
6882: WHERE lnh.loan_id = amort1.loan_id(+)
6883: AND lnh.loan_id = p_loan_id
6884: AND amort1.reamortization_amount > 0;
6885:

Line 6904: from lns_amortization_scheds

6900: select decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(lnh.loan_id),
6901: 0,
6902: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
6903: (select max(due_date)
6904: from lns_amortization_scheds
6905: where reversed_flag = 'N'
6906: and loan_id = lnh.loan_id
6907: and phase = lnh.current_phase))
6908: from lns_loan_headers lnh

Line 9092: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS

9088: || Parameter: loan_id
9089: ||
9090: || Return value: Amount Or BALANCE on loan
9091: ||
9092: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS
9093: ||
9094: || Target Tables: NA
9095: ||
9096: || KNOWN ISSUES