APPS.POR_CONTRACTOR_NOTIFY dependencies on FND_LANGUAGES_VL

Line 402: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

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

Line 409: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

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