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 444: from lns_amortization_scheds

440: else
441: -- over interest charge had no previous applications
442: select interest_amount + l_payoff_tbl2(i).unbilled_amount
443: into l_new_interest
444: from lns_amortization_scheds
445: where loan_id = p_loan_id
446: and reamortization_amount is null
447: and parent_amortization_id is null
448: --and reversed_flag = 'N'

Line 771: from lns_amortization_scheds am

767: ,am.due_date
768: ,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
769: ,ps.TRX_DATE
770: ,ps.GL_DATE
771: from lns_amortization_scheds am
772: ,ar_payment_schedules ps
773: ,ra_cust_trx_types tty
774: where (am.principal_trx_id = ps.customer_trx_id OR
775: am.interest_trx_id = ps.customer_trx_id OR

Line 794: from lns_amortization_scheds

790:
791: cursor c_lastInterestAmount(p_loan_id number)
792: is
793: select interest_amount
794: from lns_amortization_scheds
795: where loan_id = p_loan_id
796: and reversed_flag <> 'Y'
797: and reamortization_amount is null
798: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

Line 1513: from lns_amortization_scheds am

1509: ,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
1510: ,ps.due_date
1511: ,ps.TRX_DATE
1512: ,ps.GL_DATE
1513: from lns_amortization_scheds am
1514: ,ar_payment_schedules ps
1515: ,ra_cust_trx_types tty
1516: where (am.principal_trx_id = ps.customer_trx_id OR
1517: am.interest_trx_id = ps.customer_trx_id OR

Line 2697: ,lns_amortization_scheds am

2693: ,decode(ps.customer_trx_id, am.principal_trx_Id, 'PRIN', am.interest_trx_id, 'INT', am.fee_trx_id, 'FEE')
2694: ,ps.trx_date
2695: ,ps.gl_date
2696: from lns_loan_headers loan
2697: ,lns_amortization_scheds am
2698: ,ar_payment_schedules ps
2699: where loan.loan_id = P_LOAN_ID and
2700: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and
2701: ps.customer_trx_id in (am.principal_trx_id, am.interest_trx_id, am.fee_trx_id);

Line 3428: lns_amortization_scheds am

3424: SELECT psa.payment_schedule_id,
3425: am.AMORTIZATION_SCHEDULE_ID
3426: FROM ar_payment_schedules_all psa,
3427: LNS_LOAN_HEADERS_ALL loan,
3428: lns_amortization_scheds am
3429: WHERE loan.loan_id = am.loan_id and
3430: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and
3431: am.PAYMENT_NUMBER = loan.LAST_PAYMENT_NUMBER and
3432: loan.loan_id = P_LOAN_ID and