APPS.PAY_NZ_SOE_PKG dependencies on HR_LOCATIONS

Line 176: from hr_locations hrl,

172: substr(hrl.address_line_3,1,27),
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;