211: SYSDATE,
212: NULL,
213: L.LANGUAGE_CODE,
214: userenv('LANG')
215: from FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and not exists
218: (select NULL
219: from JTF_CAL_SHIFTS_TL T
623: B.LAST_UPDATE_DATE,
624: B.LAST_UPDATE_LOGIN,
625: L.LANGUAGE_CODE,
626: B.SOURCE_LANG
627: from JTF_CAL_SHIFTS_TL B, FND_LANGUAGES L
628: where L.INSTALLED_FLAG in ('I', 'B')
629: and B.LANGUAGE = userenv('LANG')
630: and not exists
631: (select NULL