1046: into v_blvl, v_clvl
1047: from AD_TE_LEVEL_HISTORY
1048: where abbreviation=te.abbreviation;
1049:
1050: update ad_trackable_entities
1051: set baseline=v_blvl, codelevel=v_clvl
1052: where abbreviation=te.abbreviation;
1053: exception
1054: when no_data_found
1052: where abbreviation=te.abbreviation;
1053: exception
1054: when no_data_found
1055: then
1056: delete ad_trackable_entities
1057: where abbreviation=te.abbreviation;
1058: when others then null;
1059: end;
1060: end loop;