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 1154: -- then insert reamortization information into LNS_AMORTIZATION_SCHEDS

1150: -- Api body
1151: -- get the loan details
1152: -- compare the actual balance to the theoretical balance
1153: -- if they are inconsistent and reamorization flag is set
1154: -- then insert reamortization information into LNS_AMORTIZATION_SCHEDS
1155: /*
1156: if p_installment_number = 0 then
1157: i := p_installment_number + 1;
1158: else

Line 1282: from lns_amortization_scheds

1278: -- remove all reAmortize rows from amortization schedule
1279: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' removing previous reAmortize rows');
1280:
1281: delete
1282: from lns_amortization_scheds
1283: where loan_id = p_loan_id
1284: and reamortization_amount is not null
1285: and reamortize_from_installment is not null;
1286:

Line 1289: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id

1285: and reamortize_from_installment is not null;
1286:
1287: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' REAMORTIZE OVERPAY LOAN');
1288: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' insert record into amortizations');
1289: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id
1290: ,loan_id
1291: ,reamortization_amount
1292: ,reamortize_from_installment
1293: ,reamortize_to_installment

Line 1300: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL

1296: ,last_updated_by
1297: ,last_update_date
1298: ,object_version_number)
1299: values
1300: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL
1301: ,p_loan_id
1302: ,l_actual_balance
1303: ,p_installment_number
1304: ,null

Line 1316: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id

1312: /*
1313: elsif l_loan_details.reamortize_underpay = 'Y' and l_actual_balance > l_theoretical_balance then
1314: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' REAMORTIZE UNDERPAY LOAN');
1315: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' insert record into amortizations');
1316: insert into LNS_AMORTIZATION_SCHEDS(amortization_schedule_id
1317: ,loan_id
1318: ,reamortization_amount
1319: ,reamortize_from_installment
1320: ,reamortize_to_installment

Line 1327: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL

1323: ,last_updated_by
1324: ,last_update_date
1325: ,object_version_number)
1326: values
1327: (LNS_AMORTIZATION_SCHEDS_S.NEXTVAL
1328: ,p_loan_id
1329: ,l_actual_balance
1330: ,p_installment_number
1331: ,null

Line 2487: from lns_amortization_scheds

2483:
2484: -- get last billed principal info
2485: cursor c_get_last_payment(p_loan_id number, p_installment_number number) is
2486: select PRINCIPAL_AMOUNT, PAYMENT_NUMBER
2487: from lns_amortization_scheds
2488: where loan_id = p_loan_id
2489: and PAYMENT_NUMBER > 0
2490: and PAYMENT_NUMBER <= p_installment_number
2491: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')

Line 2501: from LNS_AMORTIZATION_SCHEDS

2497:
2498: -- get infor from last billed installment
2499: cursor c_get_funded_amount(p_loan_id number, p_installment_number number) is
2500: select FUNDED_AMOUNT, nvl(CAP_INT_AMOUNT, 0)
2501: from LNS_AMORTIZATION_SCHEDS
2502: where loan_id = p_loan_id
2503: and PAYMENT_NUMBER = p_installment_number
2504: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
2505: and PARENT_AMORTIZATION_ID is null

Line 3888: from lns_amortization_scheds

3884:
3885: -- get last billed principal info
3886: cursor c_get_last_payment(p_loan_id number, p_installment_number number) is
3887: select PRINCIPAL_AMOUNT, FUNDED_AMOUNT, nvl(CAP_INT_AMOUNT, 0)
3888: from lns_amortization_scheds
3889: where loan_id = p_loan_id
3890: and PAYMENT_NUMBER > 0
3891: and PAYMENT_NUMBER <= p_installment_number
3892: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')

Line 5114: from lns_amortization_scheds

5110: select (PRINCIPAL_AMOUNT + INTEREST_AMOUNT + nvl(CURR_CAP_INT_AMOUNT, 0)),
5111: nvl(FUNDED_AMOUNT, 0),
5112: nvl(CAP_INT_AMOUNT, 0),
5113: amortization_schedule_id
5114: from lns_amortization_scheds
5115: where loan_id = p_loan_id
5116: and PAYMENT_NUMBER > 0
5117: and PAYMENT_NUMBER = p_installment_number
5118: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')

Line 5128: from LNS_AMORTIZATION_SCHEDS

5124:
5125: -- get first billed installment number
5126: cursor c_first_billed_instal(p_loan_id number) is
5127: select min(PAYMENT_NUMBER)
5128: from LNS_AMORTIZATION_SCHEDS
5129: where loan_id = p_loan_id
5130: and PAYMENT_NUMBER > 0
5131: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
5132: and PARENT_AMORTIZATION_ID is null

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

7624: || Parameter: loan_id
7625: ||
7626: || Return value: table of dates
7627: ||
7628: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS
7629: ||
7630: || Target Tables: NA
7631: ||
7632: || KNOWN ISSUES

Line 7739: -- this is temporary place on LNS_AMORTIZATION_SCHEDS

7735: AND t.loan_id = h.loan_id
7736: AND curr.currency_code = h.loan_currency;
7737:
7738: -- get reamortization information
7739: -- this is temporary place on LNS_AMORTIZATION_SCHEDS
7740: -- we should move this to LNS_TERMS when we have terms realignment
7741: -- bug# 5664316 - we only store ONE reamortization row
7742: CURSOR c_reamortization(p_Loan_id NUMBER) IS
7743: SELECT nvl(reamortization_amount, 0)

Line 7747: lns_amortization_scheds amort1

7743: SELECT nvl(reamortization_amount, 0)
7744: ,nvl(reamortize_from_installment, 0)
7745: ,nvl(reamortize_to_installment, 0)
7746: FROM lns_loan_headers_all lnh,
7747: lns_amortization_scheds amort1
7748: WHERE lnh.loan_id = amort1.loan_id(+)
7749: AND lnh.loan_id = p_loan_id
7750: AND amort1.reamortization_amount > 0;
7751:

Line 7770: from lns_amortization_scheds

7766: select decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(lnh.loan_id),
7767: 0,
7768: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
7769: (select max(due_date)
7770: from lns_amortization_scheds
7771: where reversed_flag = 'N'
7772: and loan_id = lnh.loan_id
7773: and phase = lnh.current_phase))
7774: from lns_loan_headers lnh

Line 9107: from LNS_AMORTIZATION_SCHEDS

9103: and ACTIVITY_CODE in ('BILLING', 'START');
9104:
9105: cursor c_get_def_cap_amounts(p_loan_id number, p_installment_number number) is
9106: select nvl(DEFERRED_INT_AMOUNT, 0), nvl(CAP_INT_AMOUNT, 0)
9107: from LNS_AMORTIZATION_SCHEDS
9108: where loan_id = p_loan_id
9109: and PAYMENT_NUMBER = p_installment_number
9110: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
9111: and PARENT_AMORTIZATION_ID is null

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

10157: || Parameter: loan_id
10158: ||
10159: || Return value: Amount Or BALANCE on loan
10160: ||
10161: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS
10162: ||
10163: || Target Tables: NA
10164: ||
10165: || KNOWN ISSUES