APPS.FND_MLS_REQUEST dependencies on FND_TERRITORIES

Line 420: from fnd_languages a, fnd_territories b

416: else
417: begin
418: select nls_language, b.nls_territory
419: into P_LANG(i).nls_language, P_LANG(i).nls_territory
420: from fnd_languages a, fnd_territories b
421: where language_code = P_LANG(i).lang_code
422: and territory_code = P_LANG(i).terr_code;
423: exception
424: when no_data_found then

Line 464: from fnd_territories

460: else
461: begin
462: select nls_territory
463: into P_LANG(i).nls_territory
464: from fnd_territories
465: where territory_code = P_LANG(i).terr_code;
466: exception
467: when no_data_found then
468: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');

Line 641: from fnd_territories

637: if ( P_LANG(ind).terr_code is NOT NULL ) then
638: begin
639: select nls_territory
640: into P_LANG(ind).nls_territory
641: from fnd_territories
642: where territory_code = P_LANG(ind).terr_code;
643: exception
644: when no_data_found then
645: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');

Line 751: from fnd_territories

747: -- else use the default for the language
748: if P_LANG(ind).nls_territory is not null then
749: select territory_code
750: into iso_terr
751: from fnd_territories
752: where nls_territory = P_LANG(ind).nls_territory
753: and obsolete_flag = 'N';
754: end if;
755: