28:
29: SELECT lookup1.meaning, lookup2.meaning
30: INTO X_type_name,
31: X_data_type_name
32: FROM cn_lookups lookup1,
33: cn_lookups lookup2
34: WHERE lookup1.lookup_type = 'COLUMN_TYPE'
35: AND lookup1.lookup_code = X_column_type
36: AND lookup2.lookup_type = 'DATA_TYPE'
29: SELECT lookup1.meaning, lookup2.meaning
30: INTO X_type_name,
31: X_data_type_name
32: FROM cn_lookups lookup1,
33: cn_lookups lookup2
34: WHERE lookup1.lookup_type = 'COLUMN_TYPE'
35: AND lookup1.lookup_code = X_column_type
36: AND lookup2.lookup_type = 'DATA_TYPE'
37: AND lookup2.lookup_code = X_data_type;