DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PER_ADDRESSES

Line 88: from per_addresses pa,

84:
85: cursor c_geo_county_change_adds (p_patch_name in varchar)
86: is
87: select count(person_id)
88: from per_addresses pa,
89: pay_us_modified_geocodes pmod,
90: pay_us_states pus
91: where pmod.state_code = pus.state_code
92: and (( pa.country = decode(pus.state_code,70,'CA','US')