150: X_CREATED_BY,
151: L.LANGUAGE_CODE,
152: userenv('LANG'),
153: X_ORG_ID
154: FROM FND_LANGUAGES L
155: WHERE L.INSTALLED_FLAG IN ('I', 'B')
156: AND NOT EXISTS
157: (SELECT NULL
158: FROM CN_MODULES_ALL_TL T
529: B.CREATION_DATE,
530: B.CREATED_BY,
531: L.LANGUAGE_CODE,
532: B.SOURCE_LANG
533: FROM CN_MODULES_ALL_TL B, FND_LANGUAGES L
534: WHERE L.INSTALLED_FLAG IN ('I', 'B')
535: AND B.LANGUAGE = userenv('LANG')
536: AND NOT EXISTS
537: (SELECT NULL
672: user_id,
673: x_org_id,
674: L.LANGUAGE_CODE,
675: userenv('LANG')
676: FROM FND_LANGUAGES L
677: WHERE L.INSTALLED_FLAG IN ('I', 'B')
678: AND NOT EXISTS
679: (SELECT NULL
680: FROM CN_MODULES_ALL_TL T