252: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);
253:
254: CURSOR c_loan_product(pLoanProductId Number, pOrgId Number) IS
255: select loan_product_name,MAX_REQUESTED_AMOUNT
256: from lns_loan_products_all_vl
257: where loan_product_id = pLoanProductId
258: and org_id = pOrgId;
259:
260: --Need to define separate table types for each column for bulk insert since table type with all columns is not supported for bulk processing