48:
49: /* retrieve the classification id given the classification */
50: select count(classification_id)
51: into l_count
52: from cct_classifications
53: where classification = rec.classification;
54:
55: if (l_count = 1) then
56: select classification_id
54:
55: if (l_count = 1) then
56: select classification_id
57: into l_classification_id
58: from cct_classifications
59: where classification = rec.classification;
60: else
61: l_classification_id := -999;
62: end if;