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 4817: pay_us_zip_codes z

4813: IF (nvl(hr_general2.get_oracle_db_version, 0) < 9.0) THEN
4814: SELECT /*+ ORDERED */ a.state_code||'-'||a.county_code||'-'||a.city_code
4815: INTO l_geocode
4816: FROM pay_us_city_names a,
4817: pay_us_zip_codes z
4818: WHERE a.city_name = l_query_city_name
4819: AND z.state_code = a.state_code AND
4820: z.county_code = a.county_code AND
4821: z.city_code = a.city_code AND

Line 4829: pay_us_zip_codes z

4825: -- Removed the ORDERED hint for the Bug# 5629688.
4826: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4827: INTO l_geocode
4828: FROM pay_us_city_names a,
4829: pay_us_zip_codes z
4830: WHERE a.city_name = l_query_city_name
4831: AND z.state_code = a.state_code AND
4832: z.county_code = a.county_code AND
4833: z.city_code = a.city_code AND

Line 4856: FROM pay_us_zip_codes z,

4852:
4853: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4854: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4855: INTO l_geocode
4856: FROM pay_us_zip_codes z,
4857: pay_us_city_names a,
4858: pay_us_counties b
4859: WHERE a.city_name = l_query_city_name
4860: AND a.county_code = b.county_code

Line 4883: FROM pay_us_zip_codes z,

4879: WHEN TOO_MANY_ROWS THEN
4880: hr_utility.set_location('hr_us_ff_udfs.addr_val', 9);
4881: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4882: INTO l_geocode
4883: FROM pay_us_zip_codes z,
4884: pay_us_city_names a,
4885: pay_us_counties b,
4886: pay_us_states c
4887: WHERE c.state_code = a.state_code AND