APPS.OTA_SRT_UPD dependencies on FND_LANGUAGES

Line 450: from fnd_languages l

446: select l.language_code
447: , l.nls_language
448: , rd.id_flex_num
449: , rd.resource_definition_id
450: from fnd_languages l
451: , ota_suppliable_resources rs
452: , ota_resource_definitions rd
453: where rs.supplied_resource_id = p_supplied_resource_id
454: and rd.resource_definition_id = rs.resource_definition_id

Line 458: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

454: and rd.resource_definition_id = rs.resource_definition_id
455: and l.installed_flag IN ('B', 'I');
456:
457: --
458: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
459: --
460: l_srt_rec ota_srt_shd.g_rec_type;
461: --
462: l_proc varchar2(72) := g_package||'upd_key_flex_meanings';