APPS.JTF_NOTES_PKG dependencies on FND_LANGUAGES

Line 125: from FND_LANGUAGES L

121: X_CREATED_BY,
122: X_LAST_UPDATE_LOGIN,
123: L.LANGUAGE_CODE,
124: userenv('LANG')
125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B');
127:
128: If X_Notes_Detail is not null then
129: JTF_NOTES_PUB.writedatatolob(X_JTF_NOTE_ID,X_NOTES_DETAIL);

Line 462: from JTF_NOTES_TL B, FND_LANGUAGES L

458: B.CREATED_BY,
459: B.LAST_UPDATE_LOGIN,
460: L.LANGUAGE_CODE,
461: B.SOURCE_LANG
462: from JTF_NOTES_TL B, FND_LANGUAGES L
463: where L.INSTALLED_FLAG in ('I', 'B')
464: and B.LANGUAGE = userenv('LANG')
465: and not exists
466: (select NULL

Line 499: from JTF_NOTES_TL B, FND_LANGUAGES L

495: B.CREATED_BY,
496: B.LAST_UPDATE_LOGIN,
497: L.LANGUAGE_CODE,
498: B.SOURCE_LANG
499: from JTF_NOTES_TL B, FND_LANGUAGES L
500: where L.INSTALLED_FLAG in ('I', 'B')
501: and B.LANGUAGE = userenv('LANG')
502: ) v, JTF_NOTES_TL t
503: where t.JTF_NOTE_ID(+) = v.JTF_NOTE_ID