DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on FND_TERRITORIES_TL

Line 130: fnd_territories_tl ftt

126: substr(pad.town_or_city,1,27),
127: pad.postal_code,
128: substr(ftt.territory_short_name,1,27)
129: from per_addresses pad,
130: fnd_territories_tl ftt
131: where pad.country = ftt.territory_code
132: and ftt.language = USERENV('LANG') -- Bug 3257888
133: and pad.person_id = cp_person_id
134: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);

Line 177: fnd_territories_tl ftt

173: substr(hrl.town_or_city,1,27),
174: hrl.postal_code,
175: substr(ftt.territory_short_name,1,27)
176: from hr_locations hrl,
177: fnd_territories_tl ftt
178: where hrl.country = ftt.territory_code
179: and ftt.language = USERENV('LANG') -- Bug 3257888
180: and hrl.location_id = cp_location_id;
181: