DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PER_ADDRESSES

Line 3382: from per_addresses addr,

3378: substr(addr.town_or_city,1,20),
3379: substr(addr.region_1 ,1,20),
3380: substr(addr.region_2 ,1,5),
3381: substr(addr.postal_code ,1,10)
3382: from per_addresses addr,
3383: per_all_people_f ppf
3384: where addr.person_id = ppf.person_id
3385: and ppf.person_id in
3386: (select distinct person_id