APPS.GHR_SF52_DO_UPDATE dependencies on PAY_US_ZIP_CODES
Line 3371: pay_us_zip_codes z
3367: select c.county_name
3368: from pay_us_counties c ,
3369: pay_us_city_names t ,
3370: pay_us_states s, 3371: pay_us_zip_codes z 3372: where s.state_abbrev = p_pa_request_rec.forwarding_region_2
3373: and t.city_name = p_pa_request_rec.forwarding_town_or_city
3374: and t.state_code = s.state_code
3375: and t.state_code = c.state_code