239: l_bulk_process VARCHAR2(1);
240:
241: CURSOR c_check_existing_line(pLoanId Number) IS
242: select 'Y' line_exists 243: from dual 244: where exists
245: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);
246:
247: CURSOR c_loan_product(pLoanProductId Number, pOrgId Number) IS