51: X_NOTE_DETAIL_ID,
52: X_NOTE_HEADER_ID,
53: L.LANGUAGE_CODE,
54: userenv('LANG')
55: from FND_LANGUAGES L
56: where L.INSTALLED_FLAG in ('I', 'B')
57: and not exists
58: (
59: select NULL
207: B.NOTE_HEADER_ID,
208: L.LANGUAGE_CODE,
209: B.SOURCE_LANG
210: from PN_NOTE_DETAILS B,
211: FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists
215: (