APPS.CNSYIN_COLUMNS_PKG dependencies on CN_LOOKUPS

Line 30: FROM cn_lookups lookup1, cn_lookups lookup2

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