91: ,sysdate
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.user_id
95: FROM FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: AND L.LANGUAGE_CODE = userenv('LANG')
98: AND not exists
99: (select NULL
122: ,sysdate
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.user_id
126: FROM FND_LANGUAGES L, LNS_CONDITIONS_TL SourceTL
127: where L.INSTALLED_FLAG in ('I', 'B')
128: and L.LANGUAGE_CODE <> userenv('LANG')
129: AND SourceTL.language = L.LANGUAGE_CODE
130: AND SourceTL.CONDITION_ID = (
398: B.CREATED_BY,
399: B.LAST_UPDATE_LOGIN,
400: L.LANGUAGE_CODE,
401: B.SOURCE_LANG
402: from LNS_COND_ASSIGNMENTS_TL B, FND_LANGUAGES L
403: where L.INSTALLED_FLAG in ('I', 'B')
404: and B.LANGUAGE = userenv('LANG')
405: and not exists
406: (select NULL