APPS.LNS_CUSTOM_PUB dependencies on LNS_AM_SCHEDS_V

Line 1652: from LNS_AM_SCHEDS_V amort

1648: cursor c_balanceInfo(p_loan_id NUMBER, p_phase varchar2) IS
1649: select nvl(sum(amort.PRINCIPAL_AMOUNT),0) -- billed principal
1650: ,nvl(sum(amort.PRINCIPAL_REMAINING),0) -- unpaid principal
1651: ,nvl(sum(amort.INTEREST_REMAINING),0) -- unpaid interest
1652: from LNS_AM_SCHEDS_V amort
1653: where amort.Loan_id = p_loan_id
1654: and amort.REVERSED_CODE = 'N'
1655: and amort.phase = p_phase;
1656: