DBA Data[Home] [Help]

APPS.CN_IMPORT_PVT dependencies on CN_IMP_MAP_FIELDS

Line 960: FROM cn_imp_map_fields f, cn_imp_maps m

956:
957: CURSOR c_tar_col_cv(c_imp_map_id NUMBER) IS
958: SELECT f.source_column,f.target_column_name,f.target_table_name,
959: m.object_version_number map_obj_ver
960: FROM cn_imp_map_fields f, cn_imp_maps m
961: WHERE m.imp_map_id = c_imp_map_id
962: AND f.imp_map_id = m.imp_map_id
963: ORDER BY f.source_column
964: ;

Line 1239: FROM cn_imp_headers h, cn_imp_map_fields f

1235: IS
1236: CURSOR c_src_col_csr IS
1237: SELECT f.source_column,f.source_user_column,
1238: f.target_column_name,f.target_table_name
1239: FROM cn_imp_headers h, cn_imp_map_fields f
1240: WHERE h.imp_header_id = p_imp_header_id
1241: AND f.imp_map_id = h.imp_map_id
1242: ORDER BY f.source_column
1243: ;

Line 1245: l_table_name cn_imp_map_fields.target_column_name%TYPE ;

1241: AND f.imp_map_id = h.imp_map_id
1242: ORDER BY f.source_column
1243: ;
1244: l_src_col_csr c_src_col_csr%ROWTYPE;
1245: l_table_name cn_imp_map_fields.target_column_name%TYPE ;
1246: l_errbuf VARCHAR2(2000);
1247:
1248: BEGIN
1249: x_header_list := NULL;