[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(max(am.PAYMENT_NUMBER), 0)
from LNS_AMORTIZATION_SCHEDS am,
lns_loan_headers head
where am.LOAN_ID = P_LOAN_ID and
am.LOAN_ID = head.LOAN_ID
and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
and am.PARENT_AMORTIZATION_ID is null
and nvl(am.PHASE, 'TERM') = nvl(head.CURRENT_PHASE, 'TERM');
select nvl(max(am.PAYMENT_NUMBER), 0)
from LNS_AMORTIZATION_SCHEDS am,
lns_loan_headers head
where am.LOAN_ID = P_LOAN_ID
and am.LOAN_ID = head.LOAN_ID
and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
and am.PARENT_AMORTIZATION_ID is null
and am.REAMORTIZATION_AMOUNT is null
and nvl(am.PHASE, 'TERM') = nvl(P_PHASE, nvl(head.CURRENT_PHASE, 'TERM'));
select nvl(max(am.PAYMENT_NUMBER), -1)
from LNS_AMORTIZATION_SCHEDS am,
lns_loan_headers head
where am.LOAN_ID = P_LOAN_ID and
am.LOAN_ID = head.LOAN_ID
and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
-- and am.PARENT_AMORTIZATION_ID is null
and am.REAMORTIZATION_AMOUNT is null -- fix for bug 7422383
and nvl(am.PHASE, 'TERM') = nvl(head.CURRENT_PHASE, 'TERM');
select nvl(max(am.AMORTIZATION_SCHEDULE_ID), -1)
from LNS_AMORTIZATION_SCHEDS am,
lns_loan_headers head
where am.LOAN_ID = P_LOAN_ID
and am.LOAN_ID = head.LOAN_ID
and am.PAYMENT_NUMBER = LAST_PAYMENT_NUMBER(am.LOAN_ID)
and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
and am.PARENT_AMORTIZATION_ID is null
and nvl(am.PHASE, 'TERM') = nvl(head.CURRENT_PHASE, 'TERM');
select loan.funded_amount -
(select nvl(sum(rec.amount_applied), 0)
from
ar_receivable_applications_all rec,
LNS_AMORTIZATION_SCHEDS am
where
rec.application_type = 'CASH' and
trunc(rec.apply_date) <= trunc(P_DATE) and
rec.APPLIED_CUSTOMER_TRX_ID = am.principal_trx_id and
rec.org_id = loan.org_id and
am.loan_id = loan.loan_id and
am.principal_trx_id is not null and
nvl(am.PHASE, 'TERM') = nvl(loan.CURRENT_PHASE, 'TERM'))
from lns_loan_headers_all loan
where loan.loan_id = P_LOAN_ID;