APPS.PAY_GB_EOY_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 3076: l_country_name fnd_territories_tl.territory_short_name%type;

3072: l_address_line2 per_addresses.address_line2%type;
3073: l_address_line3 per_addresses.address_line3%type;
3074: l_town_or_city VARCHAR2(30);
3075: l_county VARCHAR2(27);
3076: l_country_name fnd_territories_tl.territory_short_name%type;
3077: l_country per_addresses.country%type;
3078: l_postal_code VARCHAR2(8);
3079: --
3080: l_ni_tot NUMBER:= 0;

Line 3378: FROM fnd_territories_tl ftt

3374: AND nvl(pad.date_to, sysdate);
3375: --
3376: cursor csr_country_name(p_country_code VARCHAR2) IS
3377: SELECT substr(ftt.territory_short_name, 1, 35) country -- 4011263
3378: FROM fnd_territories_tl ftt
3379: WHERE ftt.territory_code = p_country_code
3380: AND ftt.language = userenv('LANG');
3381: --
3382: -- fetch the scon balances for NI F, NI G and/or NI S