APPS.LNS_REP_UTILS dependencies on LNS_LOAN_PRODUCTS_ALL_VL

Line 422: FROM lns_loan_products_all_vl

418: IF product_id is NOT NULL
419: THEN
420: SELECT loan_product_name
421: INTO l_loan_product_name
422: FROM lns_loan_products_all_vl
423: WHERE loan_product_id = product_id;
424: END IF;
425: IF loan_assigned_to is NOT NULL
426: THEN

Line 1552: lns_loan_products_all_vl product

1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,
1552: lns_loan_products_all_vl product
1553: where
1554: lh.primary_borrower_id = hp.party_id and
1555: --lh.loan_id = pay.loan_id and --Bug5262505
1556: lh.loan_id = t.loan_id and