119: P_NAME,
120: P_DESCRIPTION,
121: L.LANGUAGE_CODE,
122: userenv('LANG')
123: from FND_LANGUAGES L
124: where L.INSTALLED_FLAG in ('I', 'B')
125: and not exists
126: (select NULL
127: from CSD_SERVICE_CODES_TL T
455: B.NAME,
456: B.DESCRIPTION,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from CSD_SERVICE_CODES_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL