APPS.CN_IMP_MAPS_PVT dependencies on CN_IMPORT_TYPES

Line 142: FROM cn_imp_maps m, cn_import_types t

138:
139: -- get target_table_id,target_table_name
140: SELECT t.table_id,t.view_name
141: INTO l_imp_map_field.target_table_id,l_imp_map_field.target_table_name
142: FROM cn_imp_maps m, cn_import_types t
143: WHERE m.imp_map_id = l_imp_map.imp_map_id
144: AND m.import_type_code = t.import_type_code
145: ;
146:

Line 381: FROM cn_import_types

377: x_target_fields := G_MISS_MAP_FIELD_TBL;
378: x_mapped_fields := G_MISS_MAP_FIELD_TBL;
379: -- get table_id
380: SELECT table_id INTO l_table_id
381: FROM cn_import_types
382: WHERE import_type_code = p_import_type_code
383: ;
384:
385: -- if p_imp_map_id is null, get default source/target/mapped field