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_AM_SCHEDS_V

Line 6892: from LNS_AM_SCHEDS_V amort

6888: cursor c_balanceInfo(p_loan_id NUMBER, p_phase varchar2) IS
6889: select nvl(sum(amort.PRINCIPAL_AMOUNT),0) -- billed principal
6890: ,nvl(sum(amort.PRINCIPAL_REMAINING),0) -- unpaid principal
6891: ,nvl(sum(amort.INTEREST_REMAINING),0) -- unpaid interest
6892: from LNS_AM_SCHEDS_V amort
6893: where amort.Loan_id = p_loan_id
6894: and amort.REVERSED_CODE = 'N'
6895: and amort.phase = p_phase;
6896:

Line 8396: from LNS_AM_SCHEDS_V SCHED

8392: ,nvl(sum(SCHED.FEE_REMAINING),0)
8393: into l_principal_unpaid
8394: ,l_interest_unpaid
8395: ,l_fees_unpaid
8396: from LNS_AM_SCHEDS_V SCHED
8397: ,LNS_LOAN_HEADERS H
8398: where H.loan_id = p_loan_id and
8399: H.loan_id = Sched.loan_id and
8400: SCHED.reversed_code = 'N' and