APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on HR_LOCATIONS_ALL

Line 104: from hr_locations_all hl,

100:
101: cursor c_geo_county_change_locs (p_patch_name in varchar)
102: is
103: select count(location_id)
104: from hr_locations_all hl,
105: pay_us_modified_geocodes pmod,
106: pay_us_states pus
107: where pmod.state_code = pus.state_code
108: and (( hl.country = decode(pus.state_code,70,'CA','US')