APPS.LNS_PAYOFF_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 169: ,lns_amortization_scheds lam

165: ,lam.principal_trx_id
166: ,lam.fee_trx_id
167: from ar_receivable_applications rap
168: ,ar_cash_receipts rac
169: ,lns_amortization_scheds lam
170: ,ar_payment_schedules trx
171: where rap.cash_receipt_id = rac.cash_receipt_id
172: and rap.applied_customer_trx_id = trx.customer_trx_id
173: and trx.customer_trx_id = lam.interest_trx_id

Line 458: from lns_amortization_scheds

454: else
455: -- over interest charge had no previous applications
456: select interest_amount + l_payoff_tbl2(i).unbilled_amount
457: into l_new_interest
458: from lns_amortization_scheds
459: where loan_id = p_loan_id
460: and reamortization_amount is null
461: and parent_amortization_id is null
462: --and reversed_flag = 'N'

Line 859: from lns_amortization_scheds am

855: ,tty.name
856: ,amount_due_remaining
857: ,am.due_date
858: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type
859: from lns_amortization_scheds am
860: ,ar_payment_schedules ps
861: ,ra_cust_trx_types tty
862: where (am.principal_trx_id = ps.customer_trx_id OR
863: am.interest_trx_id = ps.customer_trx_id OR

Line 881: from lns_amortization_scheds

877:
878: cursor c_lastInterestAmount(p_loan_id number)
879: is
880: select interest_amount
881: from lns_amortization_scheds
882: where loan_id = p_loan_id
883: and reversed_flag <> 'Y'
884: and reamortization_amount is null
885: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);