APPS.HR_CA_FF_UDFS dependencies on PAY_US_ZIP_CODES

Line 4217: FROM pay_us_zip_codes z,

4213: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 1);
4214:
4215: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4216: INTO l_geocode
4217: FROM pay_us_zip_codes z,
4218: pay_us_city_names a
4219: WHERE a.city_name = INITCAP(p_city_name)
4220: AND
4221: z.state_code = a.state_code AND

Line 4243: FROM pay_us_zip_codes z,

4239:
4240: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4241: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4242: INTO l_geocode
4243: FROM pay_us_zip_codes z,
4244: pay_us_city_names a,
4245: pay_us_counties b
4246: WHERE a.city_name = INITCAP(p_city_name)
4247: AND a.county_code = b.county_code

Line 4270: FROM pay_us_zip_codes z,

4266: WHEN TOO_MANY_ROWS THEN
4267: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 9);
4268: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4269: INTO l_geocode
4270: FROM pay_us_zip_codes z,
4271: pay_us_city_names a,
4272: pay_us_counties b,
4273: pay_us_states c
4274: WHERE c.state_code = a.state_code AND