[Home] [Help]
2076: , b.county_code
2077: from
2078: pay_us_city_names a
2079: , pay_us_counties b
2080: , pay_us_states c
2081: , pay_us_zip_codes z
2082: where a.state_code = c.state_code
2083: and a.county_code = b.county_code
2084: and b.state_code = c.state_code
2809: --
2810: -- Description:
2811: -- If address style is 'US', validate region_2 code (state abbreviation)
2812: -- exist in the hr_lookups table if HR installation only or non-US
2813: -- legislation, or the Vertex pay_us_states table if payroll is installed
2814: -- under US legislation.
2815: --
2816: -- Pre-conditions:
2817: -- Style (p_style) must be valid.
2824: -- p_effective_date
2825: -- p_object_version_number
2826: --
2827: -- Post Success:
2828: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states
2829: -- for the given region_2 code, processing continues.
2830: --
2831: -- Post Failure:
2832: -- If address style is 'US' and a row does not exist in
2829: -- for the given region_2 code, processing continues.
2830: --
2831: -- Post Failure:
2832: -- If address style is 'US' and a row does not exist in
2833: -- hr_lookups/pay_us_states for the given region_2 code, an application
2834: -- error is raised and processing terminates.
2835: --
2836: -- Access Status:
2837: -- Internal Table Handler Use Only.
2857: -- Declare cursor
2858: --
2859: cursor csr_valid_state is
2860: select null
2861: from pay_us_states
2862: where state_abbrev = p_region_2;
2863: --
2864: begin
2865: hr_utility.set_location('Entering:'|| l_proc, 1);
2969: --
2970: -- Description:
2971: -- If address style is 'US', validate tax_state (add_information17)
2972: -- code (state abbreviation)exist in the hr_lookups table if HR
2973: -- installation only, or the Vertex pay_us_states table if payroll is installed
2974: -- under US legislation.
2975: --
2976: -- Pre-conditions:
2977: -- Style (p_style) must be valid.
2984: -- p_effective_date
2985: -- p_object_version_number
2986: --
2987: -- Post Success:
2988: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states
2989: -- for the given tax_state code, processing continues.
2990: --
2991: -- Post Failure:
2992: -- If address style is 'US' and a row does not exist in
2989: -- for the given tax_state code, processing continues.
2990: --
2991: -- Post Failure:
2992: -- If address style is 'US' and a row does not exist in
2993: -- hr_lookups/pay_us_states for the given tax_state code, an application
2994: -- error is raised and processing terminates.
2995: --
2996: -- Access Status:
2997: -- Internal Table Handler Use Only.
3017: -- Declare cursor
3018: --
3019: cursor csr_valid_state is
3020: select null
3021: from pay_us_states
3022: where state_abbrev = p_tax_state ;
3023: --
3024: begin
3025: if p_tax_state is not null
3392: cursor csr_valid_state_county
3393: is
3394: select st.state_code,
3395: cou.county_code
3396: from pay_us_states st,
3397: pay_us_counties cou
3398: where cou.state_code = st.state_code
3399: and cou.county_name =p_region_1
3400: and st.state_abbrev = p_region_2;
3423: cursor csr_val_st_city
3424: is
3425: select st.state_code
3426: from pay_us_city_names cty
3427: , pay_us_states st
3428: where cty.state_code = st.state_code
3429: and cty.city_name = p_town_or_city
3430: and st.state_abbrev = p_region_2;
3431: --
3693: cursor csr_valid_state_county
3694: is
3695: select st.state_code,
3696: cou.county_code
3697: from pay_us_states st,
3698: pay_us_counties cou
3699: where cou.state_code = st.state_code
3700: and cou.county_name = p_tax_county
3701: and st.state_abbrev = p_tax_state;
3724: cursor csr_val_st_city
3725: is
3726: select st.state_code
3727: from pay_us_city_names cty
3728: , pay_us_states st
3729: where cty.state_code = st.state_code
3730: and cty.city_name = p_tax_city
3731: and st.state_abbrev = p_tax_state;
3732: --