APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on FND_LANGUAGES_VL

Line 658: from fnd_languages_vl

654: l_returned_messageName varchar2(30);
655:
656: cursor get_nls_lang (p_dft_lang varchar2) is
657: select NLS_LANGUAGE
658: from fnd_languages_vl
659: where language_code = p_dft_lang;
660: cursor get_user_lang(p_user_name varchar2) is
661: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
662: from fnd_user usr

Line 669: from fnd_languages_vl

665: select message_name
666: from fnd_new_messages
667: where message_name = c_messageName
668: and language_code = ( select language_code
669: from fnd_languages_vl
670: where nls_language = c_language );
671: BEGIN
672: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
673: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');