[Home] [Help]
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
2103: and b.state_code = c.state_code
2828: --
2829: -- Description:
2830: -- If address style is 'US', validate region_2 code (state abbreviation)
2831: -- exist in the hr_lookups table if HR installation only or non-US
2832: -- legislation, or the Vertex pay_us_states table if payroll is installed
2833: -- under US legislation.
2834: --
2835: -- Pre-conditions:
2836: -- Style (p_style) must be valid.
2843: -- p_effective_date
2844: -- p_object_version_number
2845: --
2846: -- Post Success:
2847: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states
2848: -- for the given region_2 code, processing continues.
2849: --
2850: -- Post Failure:
2851: -- If address style is 'US' and a row does not exist in
2848: -- for the given region_2 code, processing continues.
2849: --
2850: -- Post Failure:
2851: -- If address style is 'US' and a row does not exist in
2852: -- hr_lookups/pay_us_states for the given region_2 code, an application
2853: -- error is raised and processing terminates.
2854: --
2855: -- Access Status:
2856: -- Internal Table Handler Use Only.
2876: -- Declare cursor
2877: --
2878: cursor csr_valid_state is
2879: select null
2880: from pay_us_states
2881: where state_abbrev = p_region_2;
2882: --
2883: begin
2884: hr_utility.set_location('Entering:'|| l_proc, 1);
2988: --
2989: -- Description:
2990: -- If address style is 'US', validate tax_state (add_information17)
2991: -- code (state abbreviation)exist in the hr_lookups table if HR
2992: -- installation only, or the Vertex pay_us_states table if payroll is installed
2993: -- under US legislation.
2994: --
2995: -- Pre-conditions:
2996: -- Style (p_style) must be valid.
3003: -- p_effective_date
3004: -- p_object_version_number
3005: --
3006: -- Post Success:
3007: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states
3008: -- for the given tax_state code, processing continues.
3009: --
3010: -- Post Failure:
3011: -- If address style is 'US' and a row does not exist in
3008: -- for the given tax_state code, processing continues.
3009: --
3010: -- Post Failure:
3011: -- If address style is 'US' and a row does not exist in
3012: -- hr_lookups/pay_us_states for the given tax_state code, an application
3013: -- error is raised and processing terminates.
3014: --
3015: -- Access Status:
3016: -- Internal Table Handler Use Only.
3036: -- Declare cursor
3037: --
3038: cursor csr_valid_state is
3039: select null
3040: from pay_us_states
3041: where state_abbrev = p_tax_state ;
3042: --
3043: begin
3044: if p_tax_state is not null
3411: cursor csr_valid_state_county
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;
3442: cursor csr_val_st_city
3443: is
3444: select st.state_code
3445: from pay_us_city_names cty
3446: , pay_us_states st
3447: where cty.state_code = st.state_code
3448: and cty.city_name = p_town_or_city
3449: and st.state_abbrev = p_region_2;
3450: --
3712: cursor csr_valid_state_county
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;
3743: cursor csr_val_st_city
3744: is
3745: select st.state_code
3746: from pay_us_city_names cty
3747: , pay_us_states st
3748: where cty.state_code = st.state_code
3749: and cty.city_name = p_tax_city
3750: and st.state_abbrev = p_tax_state;
3751: --