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_APPL_ENGINE_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 1504: from lns_amortization_scheds

1500:
1501: -- get all amortizations
1502: CURSOR am_scheds_cur(P_LOAN_ID number) IS
1503: select amortization_schedule_id
1504: from lns_amortization_scheds
1505: where loan_id = P_LOAN_ID and
1506: reversed_flag = 'N'
1507: order by phase, payment_number, amortization_schedule_id;
1508:

Line 1532: lns_amortization_scheds am,

1528: ps.amount_due_remaining,
1529: ps.invoice_currency_code,
1530: loan.EXCHANGE_RATE
1531: from
1532: lns_amortization_scheds am,
1533: lns_loan_headers loan,
1534: ar_payment_schedules ps,
1535: hz_parties party,
1536: lns_loan_products_vl product,

Line 1575: lns_amortization_scheds am,

1571: ps.amount_due_remaining,
1572: ps.invoice_currency_code,
1573: loan.EXCHANGE_RATE
1574: from
1575: lns_amortization_scheds am,
1576: lns_loan_headers loan,
1577: ar_payment_schedules ps,
1578: hz_parties party,
1579: lns_loan_products_vl product,

Line 1878: lns_amortization_scheds am,

1874: party.party_id = loan.primary_borrower_id and
1875: product.loan_product_id = loan.product_id and
1876: ((select count(1)
1877: from
1878: lns_amortization_scheds am,
1879: ar_payment_schedules ps
1880: where
1881: am.loan_id = loan.loan_id and
1882: (am.reversed_flag is null or am.reversed_flag = 'N') and