DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on PER_ADDRESSES

Line 129: from per_addresses pad,

125: substr(pad.address_line3,1,27),
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