382:
383: delete from GR_EXPOSURE_AUTHS_TL T
384: where not exists
385: (select NULL
386: from GR_EXPOSURE_AUTHS_B B
387: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE
388: );
389:
390: /* Redefault translations from the source language */
1140: begin
1141: delete from GR_EXPOSURE_AUTHS_TL T
1142: where not exists
1143: (select NULL
1144: from GR_EXPOSURE_AUTHS_B B
1145: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE
1146: );
1147:
1148: update GR_EXPOSURE_AUTHS_TL T set (