152: X_LAST_UPDATE_DATE,
153: X_LAST_UPDATE_LOGIN,
154: L.LANGUAGE_CODE,
155: userenv('LANG')
156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from PAY_CUSTOM_RESTRICTIONS_TL T
323: X_LAST_UPDATE_DATE,
324: X_LAST_UPDATE_LOGIN,
325: L.LANGUAGE_CODE,
326: userenv('LANG')
327: from FND_LANGUAGES L
328: where L.INSTALLED_FLAG in ('I', 'B')
329: and not exists
330: (select NULL
331: from PAY_CUSTOM_RESTRICTIONS_TL T
570: B.LAST_UPDATE_DATE,
571: B.LAST_UPDATE_LOGIN,
572: L.LANGUAGE_CODE,
573: B.SOURCE_LANG
574: from PAY_CUSTOM_RESTRICTIONS_TL B, FND_LANGUAGES L
575: where L.INSTALLED_FLAG in ('I', 'B')
576: and B.LANGUAGE = userenv('LANG')
577: and not exists
578: (select NULL