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
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