APPS.PER_ADD_BUS dependencies on PAY_US_COUNTIES

Line 2079: , pay_us_counties b

2075: , b.county_name
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

Line 2535: -- region_1 code exists in table pay_us_counties as the county code, unless

2531: -- Description:
2532: -- If address style is 'GB' then validates that a region_1 code exists in
2533: -- table hr_lookups.
2534: -- If address style is 'US' and GEOCODES is installed then validates that a
2535: -- region_1 code exists in table pay_us_counties as the county code, unless
2536: -- p_validate_county is set to FALSE.
2537: --
2538: -- Pre-conditions:
2539: -- Style (p_style) must be valid.

Line 2554: -- in pay_us_counties for the given region_1 code, processing continues.

2550: -- Post Success:
2551: -- If address style is 'GB' and a row does exist in hr_lookups
2552: -- for the given region_1 code, processing continues.
2553: -- If address style is 'US' and GEOCODES is installed a row does exist
2554: -- in pay_us_counties for the given region_1 code, processing continues.
2555: --
2556: -- Post Failure:
2557: -- If address style is 'GB' and a row does not exist in hr_lookups
2558: -- for the given region_1 code, an application error is raised

Line 2582: from pay_us_counties

2578: l_api_updating boolean;
2579: --
2580: cursor csr_valid_us_county is
2581: select null
2582: from pay_us_counties
2583: where county_name = p_region_1;
2584: --
2585: begin
2586: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2691: -- add_information19 code exists in table pay_us_counties as the county code.

2687: -- ---------------------------------------------------------------------------
2688: --
2689: -- Description:
2690: -- If address style is 'US' and GEOCODES is installed then validates that a
2691: -- add_information19 code exists in table pay_us_counties as the county code.
2692: --
2693: -- Pre-conditions:
2694: -- Style (p_style) must be valid.
2695: --

Line 2706: -- in pay_us_counties for the given add_information19 code, processing continues.

2702: -- p_object_version_number
2703: --
2704: -- Post Success:
2705: -- If address style is 'US' and GEOCODES is installed and a row does exist
2706: -- in pay_us_counties for the given add_information19 code, processing continues.
2707: --
2708: -- Post Failure:
2709: -- If address style is 'US' and GEOCODES is installed and a row does not exist
2710: -- in pay_us_counties for the given add_information19 code, processing stops

Line 2710: -- in pay_us_counties for the given add_information19 code, processing stops

2706: -- in pay_us_counties for the given add_information19 code, processing continues.
2707: --
2708: -- Post Failure:
2709: -- If address style is 'US' and GEOCODES is installed and a row does not exist
2710: -- in pay_us_counties for the given add_information19 code, processing stops
2711: -- an application error is raised
2712: -- and processing terminates.
2713: --
2714: -- Access Status:

Line 2734: from pay_us_counties

2730: l_api_updating boolean;
2731: --
2732: cursor csr_valid_us_county is
2733: select null
2734: from pay_us_counties
2735: where county_name = p_tax_county;
2736: --
2737: begin
2738: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 3397: pay_us_counties cou

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;
3401: --

Line 3698: pay_us_counties cou

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;
3702: --