APPS.PO_REQAPPROVAL_INIT1 dependencies on FND_LANGUAGES

Line 4701: FROM wf_languages wfl, fnd_languages_vl flv

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

Line 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:

Line 9628: fnd_languages fl

9624: -- Sql Why : To maintain the NO ACTION message in approver language.
9625: SELECT message_text
9626: INTO l_note
9627: FROM fnd_new_messages fm,
9628: fnd_languages fl
9629: WHERE fm.message_name = 'ICX_POR_NOTIF_TIMEOUT'
9630: AND fm.language_code = fl.language_code
9631: AND fl.nls_language = l_language;
9632: EXCEPTION