APPS.PAY_GB_RTI_P60 dependencies on FND_TERRITORIES_TL

Line 347: FROM fnd_territories_tl ftt

343: AND nvl(pad.date_to, sysdate);
344: --
345: cursor csr_country_name(p_country_code VARCHAR2) IS
346: SELECT substr(ftt.territory_short_name, 1, 35) country -- 4011263
347: FROM fnd_territories_tl ftt
348: WHERE ftt.territory_code = p_country_code
349: AND ftt.language = userenv('LANG');
350:
351: CURSOR csr_asg_num

Line 383: l_country_name fnd_territories_tl.territory_short_name%type;

379: l_address_line2 per_addresses.address_line2%type;
380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);
382: l_county VARCHAR2(27);
383: l_country_name fnd_territories_tl.territory_short_name%type;
384: l_country per_addresses.country%type;
385: l_postal_code VARCHAR2(8);
386: l_name_and_initials VARCHAR2(100);
387: l_profile_name_format VARCHAR2(100);