APPS.AMS_PROD_TEMPLATE_PKG dependencies on FND_LANGUAGES

Line 60: from AMS_PROD_TEMPLATES_TL B, FND_LANGUAGES L

56: B.template_NAME,
57: B.DESCRIPTION,
58: L.LANGUAGE_CODE,
59: B.SOURCE_LANG
60: from AMS_PROD_TEMPLATES_TL B, FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and B.LANGUAGE = userenv('LANG')
63: and not exists
64: (select NULL

Line 196: FROM fnd_languages l

192: sysdate,
193: l_user_id,
194: X_TEMPLATE_NAME,
195: X_DESCRIPTION
196: FROM fnd_languages l
197: WHERE l.installed_flag IN ('I','B')
198: AND NOT EXISTS(
199: SELECT NULL
200: FROM AMS_PROD_TEMPLATES_TL t