50: X_CREATION_DATE,
51: X_LAST_UPDATE_LOGIN,
52: L.LANGUAGE_CODE,
53: userenv('LANG')
54: from FND_LANGUAGES L
55: where L.INSTALLED_FLAG in ('I', 'B')
56: and not exists
57: (select NULL
58: from PC_TEXT_TBL_TL T
242: B.CREATION_DATE,
243: B.LAST_UPDATE_LOGIN,
244: L.LANGUAGE_CODE,
245: B.SOURCE_LANG
246: from PC_TEXT_TBL_TL B, FND_LANGUAGES L
247: where L.INSTALLED_FLAG in ('I', 'B')
248: and B.LANGUAGE = userenv('LANG')
249: and not exists
250: (select NULL