The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into AP_TERMS_TL (
TERM_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
NAME,
ENABLED_FLAG,
DUE_CUTOFF_DAY,
DESCRIPTION,
TYPE,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
RANK,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LANGUAGE,
SOURCE_LANG
) select
B.TERM_ID,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATE_LOGIN,
B.NAME,
B.ENABLED_FLAG,
B.DUE_CUTOFF_DAY,
B.DESCRIPTION,
B.TYPE,
B.START_DATE_ACTIVE,
B.END_DATE_ACTIVE,
B.RANK,
B.ATTRIBUTE_CATEGORY,
B.ATTRIBUTE1,
B.ATTRIBUTE2,
B.ATTRIBUTE3,
B.ATTRIBUTE4,
B.ATTRIBUTE5,
B.ATTRIBUTE6,
B.ATTRIBUTE7,
B.ATTRIBUTE8,
B.ATTRIBUTE9,
B.ATTRIBUTE10,
B.ATTRIBUTE11,
B.ATTRIBUTE12,
B.ATTRIBUTE13,
B.ATTRIBUTE14,
B.ATTRIBUTE15,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from AP_TERMS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.TERM_ID = P_Term_Id
and not exists
(select NULL
from AP_TERMS_TL T
where T.TERM_ID = B.TERM_ID
and T.LANGUAGE = L.LANGUAGE_CODE);