APPS.LNS_REP_UTILS dependencies on LNS_LOAN_PRODUCTS_ALL

Line 211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;

207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
210: l_legal_entity_name xle_entity_profiles.name%TYPE;
211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
212: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
213: l_loan_status1_desc lns_lookups.meaning%TYPE;
214: l_loan_status2_desc lns_lookups.meaning%TYPE;
215: l_include_charts VARCHAR2(30);

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