APPS.LNS_REP_UTILS dependencies on LNS_LOAN_PRODUCTS_ALL

Line 237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;

233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
236: l_legal_entity_name xle_entity_profiles.name%TYPE;
237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
238: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
239: l_loan_status1_desc lns_lookups.meaning%TYPE;
240: l_loan_status2_desc lns_lookups.meaning%TYPE;
241: l_include_charts VARCHAR2(30);

Line 473: FROM lns_loan_products_all_vl

469: IF product_id is NOT NULL
470: THEN
471: SELECT loan_product_name
472: INTO l_loan_product_name
473: FROM lns_loan_products_all_vl
474: WHERE loan_product_id = product_id;
475: END IF;
476: IF loan_assigned_to is NOT NULL
477: THEN

Line 1656: lns_loan_products_all_vl product

1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,
1656: lns_loan_products_all_vl product
1657: where
1658: lh.primary_borrower_id = hp.party_id and
1659: --lh.loan_id = pay.loan_id and --Bug5262505
1660: lh.loan_id = t.loan_id and