APPS.HR_CA_FF_UDFS dependencies on PAY_US_ZIP_CODES

Line 4254: FROM pay_us_zip_codes z,

4250: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 1);
4251:
4252: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4253: INTO l_geocode
4254: FROM pay_us_zip_codes z,
4255: pay_us_city_names a
4256: WHERE a.city_name = INITCAP(p_city_name)
4257: AND
4258: z.state_code = a.state_code AND

Line 4280: FROM pay_us_zip_codes z,

4276:
4277: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4278: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4279: INTO l_geocode
4280: FROM pay_us_zip_codes z,
4281: pay_us_city_names a,
4282: pay_us_counties b
4283: WHERE a.city_name = INITCAP(p_city_name)
4284: AND a.county_code = b.county_code

Line 4307: FROM pay_us_zip_codes z,

4303: WHEN TOO_MANY_ROWS THEN
4304: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 9);
4305: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4306: INTO l_geocode
4307: FROM pay_us_zip_codes z,
4308: pay_us_city_names a,
4309: pay_us_counties b,
4310: pay_us_states c
4311: WHERE c.state_code = a.state_code AND