APPS.PO_REQAPPROVAL_INIT1 dependencies on FND_LANGUAGES

Line 3982: fnd_languages_vl flv

3978: INTO l_adhocuser_lang,
3979: l_adhocuser_territory,
3980: l_lang_code
3981: FROM wf_languages wfl,
3982: fnd_languages_vl flv
3983: WHERE wfl.code = flv.language_code
3984: AND flv.nls_language = l_vendor_site_lang;
3985: ELSE
3986: SELECT wfl.nls_language,

Line 3993: fnd_languages_vl flv

3989: INTO l_adhocuser_lang,
3990: l_adhocuser_territory,
3991: l_lang_code
3992: FROM wf_languages wfl,
3993: fnd_languages_vl flv
3994: WHERE wfl.code = flv.language_code
3995: AND flv.installed_flag = 'B';
3996: END IF;
3997: --EMAILPO FPH END--

Line 4008: fnd_languages fl

4004: -- SQL What : Get the message in the Supliers language.
4005: SELECT message_text
4006: INTO l_note
4007: FROM fnd_new_messages fm,
4008: fnd_languages fl
4009: WHERE fm.message_name = 'PO_PDF_EMAIL_TEXT'
4010: AND fm.language_code = fl.language_code
4011: AND fl.nls_language = l_vendor_site_lang;
4012: EXCEPTION

Line 8385: fnd_languages fl

8381: -- Sql Why : To maintain the NO ACTION message in approver language.
8382: SELECT message_text
8383: INTO l_note
8384: FROM fnd_new_messages fm,
8385: fnd_languages fl
8386: WHERE fm.message_name = 'ICX_POR_NOTIF_TIMEOUT'
8387: AND fm.language_code = fl.language_code
8388: AND fl.nls_language = l_language;
8389: EXCEPTION