[Home] [Help]
2094: , b.county_name
2095: , b.county_code
2096: from
2097: pay_us_city_names a
2098: , pay_us_counties b
2099: , pay_us_states c
2100: , pay_us_zip_codes z
2101: where a.state_code = c.state_code
2102: and a.county_code = b.county_code
2550: -- Description:
2551: -- If address style is 'GB' then validates that a region_1 code exists in
2552: -- table hr_lookups.
2553: -- If address style is 'US' and GEOCODES is installed then validates that a
2554: -- region_1 code exists in table pay_us_counties as the county code, unless
2555: -- p_validate_county is set to FALSE.
2556: --
2557: -- Pre-conditions:
2558: -- Style (p_style) must be valid.
2569: -- Post Success:
2570: -- If address style is 'GB' and a row does exist in hr_lookups
2571: -- for the given region_1 code, processing continues.
2572: -- If address style is 'US' and GEOCODES is installed a row does exist
2573: -- in pay_us_counties for the given region_1 code, processing continues.
2574: --
2575: -- Post Failure:
2576: -- If address style is 'GB' and a row does not exist in hr_lookups
2577: -- for the given region_1 code, an application error is raised
2597: l_api_updating boolean;
2598: --
2599: cursor csr_valid_us_county is
2600: select null
2601: from pay_us_counties
2602: where county_name = p_region_1;
2603: --
2604: begin
2605: hr_utility.set_location('Entering:'|| l_proc, 1);
2706: -- ---------------------------------------------------------------------------
2707: --
2708: -- Description:
2709: -- If address style is 'US' and GEOCODES is installed then validates that a
2710: -- add_information19 code exists in table pay_us_counties as the county code.
2711: --
2712: -- Pre-conditions:
2713: -- Style (p_style) must be valid.
2714: --
2721: -- p_object_version_number
2722: --
2723: -- Post Success:
2724: -- If address style is 'US' and GEOCODES is installed and a row does exist
2725: -- in pay_us_counties for the given add_information19 code, processing continues.
2726: --
2727: -- Post Failure:
2728: -- If address style is 'US' and GEOCODES is installed and a row does not exist
2729: -- in pay_us_counties for the given add_information19 code, processing stops
2725: -- in pay_us_counties for the given add_information19 code, processing continues.
2726: --
2727: -- Post Failure:
2728: -- If address style is 'US' and GEOCODES is installed and a row does not exist
2729: -- in pay_us_counties for the given add_information19 code, processing stops
2730: -- an application error is raised
2731: -- and processing terminates.
2732: --
2733: -- Access Status:
2749: l_api_updating boolean;
2750: --
2751: cursor csr_valid_us_county is
2752: select null
2753: from pay_us_counties
2754: where county_name = p_tax_county;
2755: --
2756: begin
2757: hr_utility.set_location('Entering:'|| l_proc, 1);
3412: is
3413: select st.state_code,
3414: cou.county_code
3415: from pay_us_states st,
3416: pay_us_counties cou
3417: where cou.state_code = st.state_code
3418: and cou.county_name =p_region_1
3419: and st.state_abbrev = p_region_2;
3420: --
3713: is
3714: select st.state_code,
3715: cou.county_code
3716: from pay_us_states st,
3717: pay_us_counties cou
3718: where cou.state_code = st.state_code
3719: and cou.county_name = p_tax_county
3720: and st.state_abbrev = p_tax_state;
3721: --