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_FEE_ENGINE dependencies on LNS_AMORTIZATION_LINES

Line 430: ,lns_amortization_lines lines

426: select sched.fee_id
427: ,sched.fee_description
428: from lns_fee_schedules sched
429: ,lns_fees fees
430: ,lns_amortization_lines lines
431: ,lns_amortization_scheds am
432: where fees.fee_id = sched.fee_id
433: and lines.fee_schedule_id = sched.fee_schedule_id
434: and lines.amortization_schedule_id = am.amortization_schedule_id

Line 1411: ,lns_amortization_lines lines

1407: -- and disb_header_id is null
1408: and (not exists
1409: (select 'X'
1410: from lns_amortization_scheds am
1411: ,lns_amortization_lines lines
1412: where lines.loan_id = p_loan_id
1413: and lines.fee_schedule_id = sched.fee_schedule_id
1414: and am.loan_id = lines.loan_id
1415: and NVL(am.reversed_flag, 'N') = 'N'

Line 1420: ,lns_amortization_lines lines

1416: and am.payment_number = p_installment)
1417: or exists
1418: (select 'X'
1419: from lns_amortization_scheds am
1420: ,lns_amortization_lines lines
1421: where lines.loan_id = p_loan_id
1422: and lines.fee_schedule_id = sched.fee_schedule_id
1423: and am.loan_id = lines.loan_id
1424: and am.reversed_flag = 'Y'

Line 2416: ,lns_amortization_lines lines

2412: and fees.fee_type = p_type
2413: and (exists
2414: (select 'X'
2415: from lns_amortization_scheds am
2416: ,lns_amortization_lines lines
2417: where am.loan_id = p_loan_id
2418: and am.amortization_schedule_id = lines.amortization_schedule_id
2419: and lines.fee_schedule_id = sched.fee_schedule_id
2420: and NVL(am.reversed_flag, 'N') = 'N'