4697:
4698: --EMAILPO FPH START--
4699: IF l_vendor_site_lang is NOT NULL then
4700: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
4701: FROM wf_languages wfl, fnd_languages_vl flv
4702: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
4703: ELSE
4704: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
4705: FROM wf_languages wfl, fnd_languages_vl flv
4701: FROM wf_languages wfl, fnd_languages_vl flv
4702: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
4703: ELSE
4704: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
4705: FROM wf_languages wfl, fnd_languages_vl flv
4706: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
4707: END IF;
4708: --EMAILPO FPH END--
4709: