APPS.LNS_CUSTOM_PUB dependencies on LNS_AM_SCHEDS_V

Line 1489: from LNS_AM_SCHEDS_V amort

1485: cursor c_balanceInfo(p_loan_id NUMBER, p_phase varchar2) IS
1486: select nvl(sum(amort.PRINCIPAL_AMOUNT),0) -- billed principal
1487: ,nvl(sum(amort.PRINCIPAL_REMAINING),0) -- unpaid principal
1488: ,nvl(sum(amort.INTEREST_REMAINING),0) -- unpaid interest
1489: from LNS_AM_SCHEDS_V amort
1490: where amort.Loan_id = p_loan_id
1491: and amort.REVERSED_CODE = 'N'
1492: and amort.phase = p_phase;
1493: