275: X_LAST_UPDATE_LOGIN,
276: L.LANGUAGE_CODE,
277: userenv('LANG'),
278: x_description -- added as part of fix for bug# 6820043
279: from FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and not exists
282: (select NULL
283: from ZX_RATES_TL T
932: B.LAST_UPDATE_LOGIN,
933: L.LANGUAGE_CODE,
934: B.DESCRIPTION,/* added as part of fix for bug# 6820043 */
935: B.SOURCE_LANG
936: from ZX_RATES_TL B, FND_LANGUAGES L
937: where L.INSTALLED_FLAG in ('I', 'B')
938: and B.LANGUAGE = userenv('LANG')
939: and not exists
940: (select NULL
958:
959:
960:
961: MERGE INTO FND_LOOKUP_VALUES
962: USING (SELECT INSTALLED_FLAG,LANGUAGE_CODE FROM FND_LANGUAGES where INSTALLED_FLAG in ('I', 'B')) L
963: ON ( LOOKUP_TYPE = X_LOOKUP_TYPE and
964: LOOKUP_CODE = NVL(TAG,X_TAX_RATE_CODE)and
965: VIEW_APPLICATION_ID='0' and
966: SECURITY_GROUP_ID='0' and