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_CUSTOM_PUB dependencies on LNS_PRIN_TRX_ACTIVITIES_V

Line 2218: from LNS_PRIN_TRX_ACTIVITIES_V

2214:
2215: -- get last bill date
2216: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
2217: select ACTIVITY_DATE
2218: from LNS_PRIN_TRX_ACTIVITIES_V
2219: where loan_id = p_loan_id
2220: and PAYMENT_NUMBER = p_installment_number
2221: and ACTIVITY_CODE in ('BILLING', 'START');
2222: