148: X_LAST_UPDATE_DATE,
149: X_LAST_UPDATE_LOGIN,
150: L.LANGUAGE_CODE,
151: userenv('LANG')
152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from AR_BPA_TEMPLATES_TL T
538: B.LAST_UPDATE_DATE,
539: B.LAST_UPDATE_LOGIN,
540: L.LANGUAGE_CODE,
541: B.SOURCE_LANG
542: from AR_BPA_TEMPLATES_TL B, FND_LANGUAGES L
543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL