APPS.LNS_FINANCIALS dependencies on LNS_AM_SCHEDS_V

Line 7758: from LNS_AM_SCHEDS_V amort

7754: cursor c_balanceInfo(p_loan_id NUMBER, p_phase varchar2) IS
7755: select nvl(sum(amort.PRINCIPAL_AMOUNT),0) -- billed principal
7756: ,nvl(sum(amort.PRINCIPAL_REMAINING),0) -- unpaid principal
7757: ,nvl(sum(amort.INTEREST_REMAINING),0) -- unpaid interest
7758: from LNS_AM_SCHEDS_V amort
7759: where amort.Loan_id = p_loan_id
7760: and amort.REVERSED_CODE = 'N'
7761: and amort.phase = p_phase;
7762:

Line 9259: from LNS_AM_SCHEDS_V SCHED

9255: ,nvl(sum(SCHED.FEE_REMAINING),0)
9256: into l_principal_unpaid
9257: ,l_interest_unpaid
9258: ,l_fees_unpaid
9259: from LNS_AM_SCHEDS_V SCHED
9260: ,LNS_LOAN_HEADERS H
9261: where H.loan_id = p_loan_id and
9262: H.loan_id = Sched.loan_id and
9263: SCHED.reversed_code = 'N' and