[Home] [Help]
105: comparison in Convert_Period_
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'
137: convert_period_type,
138: ot_base_rate.
139: Bug 334245 - Add check for
140: primary flag
141: on pay_us_city_names select.
142:
143: ??? ??? 40.28 ??? ???
144:
145: 4th July 1996 hparicha 40.29 360549, 366215, 378753
233: problem where Air Force Bases (in the
234: City_name would error during processing
235: of a payroll run. Example "Elgin AFB",
236: this is how the name appears in the
237: pay_us_city_names table. however the
238: addr_val function would perform an
239: initcap to the p_city_name parameter.
240: This caused no data found. Now if the
241: last 3 characters are "AFB" do not
3057: -- State/County/City entered
3058:
3059: SELECT 'S'
3060: INTO v_valid_jurisdiction
3061: FROM PAY_US_CITY_NAMES
3062: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2)
3063: AND COUNTY_CODE = substr(p_jurisdiction_code, 4,3)
3064: AND CITY_CODE = substr(p_jurisdiction_code, 8,4)
3065: --AND PRIMARY_FLAG ='Y' -- Bug 3703863-- Commented out as this flag is 'N' for user defined cities.
4747:
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
4759: -- Bug# 5343679.
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
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
4796: AND UPPER(b.county_name) = UPPER(p_county_name) --Bug3783309-Changed Initcap to Upper.
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
4823: c.state_abbrev = UPPER(p_state_abbrev)