291: select instance_code
292: from edw_local_instance )
293: AND edw_set_of_books_id NOT IN(
294: SELECT DISTINCT edw_set_of_books_id
295: FROM edw_local_equi_set_of_books)
296: ) B,
297: EDW_FLEX_SEG_MAPPINGS_V@' || G_TARGET_LINK || ' C
298: where C.DIMENSION_SHORT_NAME = ''' || g_dimension_name|| '''
299: AND lower(C.INSTANCE_CODE)= lower(B.INSTANCE)
1214: from edw_local_instance
1215: )
1216: AND edw_set_of_books_id NOT IN(
1217: SELECT DISTINCT edw_set_of_books_id
1218: FROM edw_local_equi_set_of_books
1219: );
1220:
1221: l_temp_stmt varchar2(1000);
1222: l_source_link VARCHAR2(128);
1391: FROM edw_local_set_of_books
1392: WHERE
1393: edw_set_of_books_id=(
1394: SELECT equi_set_of_books_id
1395: FROM edw_local_equi_set_of_books
1396: WHERE edw_set_of_books_id=l_parent_set_of_books.edw_set_of_books_id
1397: );
1398:
1399: FETCH cur_edw_equi_sob INTO l_edw_equi_sob;