APPS.LNS_APPL_ENGINE_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 1434: from lns_amortization_scheds

1430:
1431: -- get all amortizations
1432: CURSOR am_scheds_cur(P_LOAN_ID number) IS
1433: select amortization_schedule_id
1434: from lns_amortization_scheds
1435: where loan_id = P_LOAN_ID and
1436: reversed_flag = 'N'
1437: order by phase, payment_number, amortization_schedule_id;
1438:

Line 1462: lns_amortization_scheds am,

1458: psa.amount_due_remaining,
1459: psa.invoice_currency_code,
1460: loan.EXCHANGE_RATE
1461: from
1462: lns_amortization_scheds am,
1463: lns_loan_headers loan,
1464: ar_payment_schedules psa,
1465: hz_parties party,
1466: lns_loan_products_vl product,

Line 1505: lns_amortization_scheds am,

1501: psa.amount_due_remaining,
1502: psa.invoice_currency_code,
1503: loan.EXCHANGE_RATE
1504: from
1505: lns_amortization_scheds am,
1506: lns_loan_headers loan,
1507: ar_payment_schedules psa,
1508: hz_parties party,
1509: lns_loan_products_vl product,

Line 1802: lns_amortization_scheds am,

1798: party.party_id = loan.primary_borrower_id and
1799: product.loan_product_id = loan.product_id and
1800: ((select count(1)
1801: from
1802: lns_amortization_scheds am,
1803: ar_payment_schedules psa
1804: where
1805: am.loan_id = loan.loan_id and
1806: (am.reversed_flag is null or am.reversed_flag = 'N') and