APPS.POR_CONTRACTOR_NOTIFY dependencies on FND_LANGUAGES_VL

Line 403: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

399:
400: IF L_VENDOR_SITE_LANG IS NOT NULL THEN
401:
402: SELECT WFL.NLS_LANGUAGE, WFL.NLS_TERRITORY INTO L_ADHOCUSER_LANG, L_ADHOCUSER_TERRITORY
403: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV
404: WHERE WFL.CODE = FLV.LANGUAGE_CODE
405: AND FLV.NLS_LANGUAGE = L_VENDOR_SITE_LANG;
406:
407: ELSE

Line 410: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

406:
407: ELSE
408:
409: SELECT WFL.NLS_LANGUAGE, WFL.NLS_TERRITORY INTO L_ADHOCUSER_LANG, L_ADHOCUSER_TERRITORY
410: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV
411: WHERE WFL.CODE = FLV.LANGUAGE_CODE
412: AND FLV.INSTALLED_FLAG = 'B';
413:
414: END IF;