APPS.FND_MLS_REQUEST dependencies on FND_TERRITORIES

Line 399: from fnd_languages a, fnd_territories b

395: else
396: begin
397: select nls_language, b.nls_territory
398: into P_LANG(i).nls_language, P_LANG(i).nls_territory
399: from fnd_languages a, fnd_territories b
400: where language_code = P_LANG(i).lang_code
401: and territory_code = P_LANG(i).terr_code;
402: exception
403: when no_data_found then

Line 443: from fnd_territories

439: else
440: begin
441: select nls_territory
442: into P_LANG(i).nls_territory
443: from fnd_territories
444: where territory_code = P_LANG(i).terr_code;
445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');

Line 612: from fnd_territories

608: if ( P_LANG(ind).terr_code is NOT NULL ) then
609: begin
610: select nls_territory
611: into P_LANG(ind).nls_territory
612: from fnd_territories
613: where territory_code = P_LANG(ind).terr_code;
614: exception
615: when no_data_found then
616: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');