[Home] [Help]
312: CURSOR c_acode IS
313: SELECT
314: attribute_type_code
315: FROM
316: ibc_attribute_types_b
317: WHERE
318: attribute_type_code = f_attr_type_code
319: AND
320: content_type_code = f_ctype_code;
318: attribute_type_code = f_attr_type_code
319: AND
320: content_type_code = f_ctype_code;
321:
322: temp IBC_ATTRIBUTE_TYPES_B.attribute_type_code%TYPE;
323: BEGIN
324: IF (f_attr_type_code IS NOT NULL) THEN
325: open c_acode;
326: fetch c_acode into temp;