DBA Data[Home] [Help]

APPS.CNREDF_COLUMNS_PKG dependencies on CN_LOOKUPS

Line 32: FROM cn_lookups lookup1,

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'

Line 33: cn_lookups lookup2

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;