235:
236:
237: CURSOR cs_lookup_prob_csr is
238: select meaning
239: from cs_lookups
240: where lookup_type = 'REQUEST_PROBLEM_CODE'
241: and lookup_code = l_problem_code;
242:
243: CURSOR cs_lookup_res_csr is
241: and lookup_code = l_problem_code;
242:
243: CURSOR cs_lookup_res_csr is
244: select meaning
245: from cs_lookups
246: where lookup_type = 'REQUEST_RESOLUTION_CODE'
247: and lookup_code = l_resolution_code;
248:
249: CURSOR cs_acc_ser_csr is