APPS.HR_US_FF_UDFS dependencies on PAY_US_ZIP_CODES

Line 110: pay_us_zip_codes where

106: Type.
107: 23-JUN-95 gpaytonm 40.19 Changed references to
108: pay_us_cities to
109: pay_us_city_names and
110: pay_us_zip_codes where
111: appropriate
112: 29-JUN-95 spanwar 40.20 Changed addr_val to convert
113: 'UNKN' city codes to '0000'
114:

Line 4752: pay_us_zip_codes z

4748: IF (nvl(hr_general2.get_oracle_db_version, 0) < 9.0) THEN
4749: SELECT /*+ ORDERED */ a.state_code||'-'||a.county_code||'-'||a.city_code
4750: INTO l_geocode
4751: FROM pay_us_city_names a,
4752: pay_us_zip_codes z
4753: WHERE a.city_name = l_query_city_name
4754: AND z.state_code = a.state_code AND
4755: z.county_code = a.county_code AND
4756: z.city_code = a.city_code AND

Line 4764: pay_us_zip_codes z

4760: -- Removed the ORDERED hint for the Bug# 5629688.
4761: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4762: INTO l_geocode
4763: FROM pay_us_city_names a,
4764: pay_us_zip_codes z
4765: WHERE a.city_name = l_query_city_name
4766: AND z.state_code = a.state_code AND
4767: z.county_code = a.county_code AND
4768: z.city_code = a.city_code AND

Line 4791: FROM pay_us_zip_codes z,

4787:
4788: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4789: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4790: INTO l_geocode
4791: FROM pay_us_zip_codes z,
4792: pay_us_city_names a,
4793: pay_us_counties b
4794: WHERE a.city_name = l_query_city_name
4795: AND a.county_code = b.county_code

Line 4818: FROM pay_us_zip_codes z,

4814: WHEN TOO_MANY_ROWS THEN
4815: hr_utility.set_location('hr_us_ff_udfs.addr_val', 9);
4816: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4817: INTO l_geocode
4818: FROM pay_us_zip_codes z,
4819: pay_us_city_names a,
4820: pay_us_counties b,
4821: pay_us_states c
4822: WHERE c.state_code = a.state_code AND