eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPL_ENGINE_PUB dependencies on LNS_LOAN_PRODUCTS_VL

Line 187: select LOAN_PRODUCT_NAME from lns_loan_products_vl where loan_product_id = P_PRODUCT_ID;

183: select party_name from hz_parties party where party_id = P_BORROWER_ID;
184:
185: /* query for product name */
186: CURSOR product_cur(P_PRODUCT_ID number) IS
187: select LOAN_PRODUCT_NAME from lns_loan_products_vl where loan_product_id = P_PRODUCT_ID;
188:
189: /* query for loan number */
190: CURSOR loan_cur(P_LOAN_ID number) IS
191: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;

Line 1536: lns_loan_products_vl product,

1532: lns_amortization_scheds am,
1533: lns_loan_headers loan,
1534: ar_payment_schedules ps,
1535: hz_parties party,
1536: lns_loan_products_vl product,
1537: lns_lookups look
1538: where
1539: am.loan_id = P_LOAN_ID and
1540: loan.loan_id = am.loan_id and

Line 1579: lns_loan_products_vl product,

1575: lns_amortization_scheds am,
1576: lns_loan_headers loan,
1577: ar_payment_schedules ps,
1578: hz_parties party,
1579: lns_loan_products_vl product,
1580: lns_lookups look
1581: where
1582: am.loan_id = P_LOAN_ID and
1583: am.amortization_schedule_id = P_AMORTIZATION_SCHED_ID and

Line 1869: lns_loan_products_vl product

1865: product.loan_product_name,
1866: loan.loan_currency
1867: from lns_loan_headers loan,
1868: hz_parties party,
1869: lns_loan_products_vl product
1870: where
1871: loan.primary_borrower_id = nvl(P_BORROWER_ID, loan.primary_borrower_id) and
1872: loan.product_id = nvl(P_PRODUCT_ID, loan.product_id) and
1873: loan.loan_id = nvl(P_LOAN_ID, loan.loan_id) and