APPS.PAY_GB_EOY_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 3191: l_country_name fnd_territories_tl.territory_short_name%type;

3187: l_address_line2 per_addresses.address_line2%type;
3188: l_address_line3 per_addresses.address_line3%type;
3189: l_town_or_city VARCHAR2(30);
3190: l_county VARCHAR2(27);
3191: l_country_name fnd_territories_tl.territory_short_name%type;
3192: l_country per_addresses.country%type;
3193: l_postal_code VARCHAR2(8);
3194: --
3195: l_ni_tot NUMBER:= 0;

Line 3507: FROM fnd_territories_tl ftt

3503: AND nvl(pad.date_to, sysdate);
3504: --
3505: cursor csr_country_name(p_country_code VARCHAR2) IS
3506: SELECT substr(ftt.territory_short_name, 1, 35) country -- 4011263
3507: FROM fnd_territories_tl ftt
3508: WHERE ftt.territory_code = p_country_code
3509: AND ftt.language = userenv('LANG');
3510: --
3511: -- fetch the scon balances for NI F, NI G and/or NI S