eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ADD_BUS dependencies on PAY_US_CITY_NAMES

Line 2097: pay_us_city_names a

2093: , z.zip_end
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

Line 3135: -- validate town_or_city exist in pay_us_city_names.

3131: -- ---------------------------------------------------------------------------
3132: --
3133: -- Description:
3134: -- If address style is 'US' and Payroll is installed under US legislation,
3135: -- validate town_or_city exist in pay_us_city_names.
3136: --
3137: -- Pre-conditions:
3138: -- Style (p_style) must be valid.
3139: --

Line 3149: -- a row exist in pay_us_city_names for the given town_or_city, processing

3145: -- p_object_version_number
3146: --
3147: -- Post Success:
3148: -- If address style is 'US', payroll is installed under US legislation and
3149: -- a row exist in pay_us_city_names for the given town_or_city, processing
3150: -- continues.
3151: --
3152: -- Post Failure:
3153: -- If address style is 'US', payroll is installed under US legislation and

Line 3154: -- a row does not exist in pay_us_city_names for the given town_or_city,

3150: -- continues.
3151: --
3152: -- Post Failure:
3153: -- If address style is 'US', payroll is installed under US legislation and
3154: -- a row does not exist in pay_us_city_names for the given town_or_city,
3155: -- an application error is raised and processing terminates.
3156: --
3157: -- Access Status:
3158: -- Internal Table Handler Use Only.

Line 3178: from pay_us_city_names

3174: -- Declare cursor
3175: --
3176: cursor csr_valid_town_or_city is
3177: select null
3178: from pay_us_city_names
3179: where city_name = p_town_or_city;
3180: begin
3181: hr_utility.set_location('Entering:'|| l_proc, 1);
3182: --

Line 3250: -- validate tax_city (add_information18) exist in pay_us_city_names.

3246: -- ---------------------------------------------------------------------------
3247: --
3248: -- Description:
3249: -- If address style is 'US' and Payroll is installed under US legislation,
3250: -- validate tax_city (add_information18) exist in pay_us_city_names.
3251: --
3252: -- Pre-conditions:
3253: -- Style (p_style) must be valid.
3254: --

Line 3264: -- a row exist in pay_us_city_names for the given tax_city, processing

3260: -- p_object_version_number
3261: --
3262: -- Post Success:
3263: -- If address style is 'US', payroll is installed under US legislation and
3264: -- a row exist in pay_us_city_names for the given tax_city, processing
3265: -- continues.
3266: --
3267: -- Post Failure:
3268: -- If address style is 'US', payroll is installed under US legislation and

Line 3269: -- a row does not exist in pay_us_city_names for the given tax_city,

3265: -- continues.
3266: --
3267: -- Post Failure:
3268: -- If address style is 'US', payroll is installed under US legislation and
3269: -- a row does not exist in pay_us_city_names for the given tax_city,
3270: -- an application error is raised and processing terminates.
3271: --
3272: -- Access Status:
3273: -- Internal Table Handler Use Only.

Line 3293: from pay_us_city_names

3289: -- Declare cursor
3290: --
3291: cursor csr_valid_tax_city is
3292: select null
3293: from pay_us_city_names
3294: where city_name = p_tax_city;
3295: begin
3296: if p_tax_city is not null
3297: then

Line 3405: l_city_code pay_us_city_names.city_code%TYPE;

3401: --
3402: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';
3403: l_api_updating boolean;
3404: l_exists number;
3405: l_city_code pay_us_city_names.city_code%TYPE;
3406: l_state_code pay_us_city_names.state_code%TYPE;
3407: l_postal_code varchar2(6);
3408: l_county_code varchar2(3);
3409: l_geocodes_installed varchar2(1);

Line 3406: l_state_code pay_us_city_names.state_code%TYPE;

3402: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';
3403: l_api_updating boolean;
3404: l_exists number;
3405: l_city_code pay_us_city_names.city_code%TYPE;
3406: l_state_code pay_us_city_names.state_code%TYPE;
3407: l_postal_code varchar2(6);
3408: l_county_code varchar2(3);
3409: l_geocodes_installed varchar2(1);
3410: --

Line 3424: from pay_us_city_names cty

3420: --
3421: cursor csr_val_st_county_city
3422: is
3423: select cty.city_code
3424: from pay_us_city_names cty
3425: where cty.state_code = l_state_code
3426: and cty.county_code = l_county_code
3427: and cty.city_name = p_town_or_city;
3428: --

Line 3432: pay_us_city_names cty

3428: --
3429: cursor csr_valid_zip_code is
3430: select 1
3431: from pay_us_zip_codes zip,
3432: pay_us_city_names cty
3433: where zip.state_code = l_state_code
3434: and zip.county_code = l_county_code
3435: and cty.city_name = p_town_or_city
3436: and zip.state_code = cty.state_code

Line 3445: from pay_us_city_names cty

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

Line 3455: pay_us_city_names cty

3451: --
3452: cursor csr_valid_zip_code_no_ncty is
3453: select 1
3454: from pay_us_zip_codes zip,
3455: pay_us_city_names cty
3456: where cty.city_name = p_town_or_city
3457: and cty.state_code = l_state_code
3458: and zip.state_code = cty.state_code
3459: and zip.city_code = cty.city_code

Line 3706: l_city_code pay_us_city_names.city_code%TYPE;

3702: --
3703: l_proc varchar2(72) := g_package||'chk_tax_city_state_zip_comb';
3704: l_api_updating boolean;
3705: l_exists number;
3706: l_city_code pay_us_city_names.city_code%TYPE;
3707: l_state_code pay_us_city_names.state_code%TYPE;
3708: l_postal_code varchar2(6);
3709: l_county_code varchar2(3);
3710: l_geocodes_installed varchar2(1);

Line 3707: l_state_code pay_us_city_names.state_code%TYPE;

3703: l_proc varchar2(72) := g_package||'chk_tax_city_state_zip_comb';
3704: l_api_updating boolean;
3705: l_exists number;
3706: l_city_code pay_us_city_names.city_code%TYPE;
3707: l_state_code pay_us_city_names.state_code%TYPE;
3708: l_postal_code varchar2(6);
3709: l_county_code varchar2(3);
3710: l_geocodes_installed varchar2(1);
3711: --

Line 3725: from pay_us_city_names cty

3721: --
3722: cursor csr_val_st_county_city
3723: is
3724: select cty.city_code
3725: from pay_us_city_names cty
3726: where cty.state_code = l_state_code
3727: and cty.county_code = l_county_code
3728: and cty.city_name = p_tax_city;
3729: --

Line 3733: pay_us_city_names cty

3729: --
3730: cursor csr_valid_zip_code is
3731: select 1
3732: from pay_us_zip_codes zip,
3733: pay_us_city_names cty
3734: where zip.state_code = l_state_code
3735: and zip.county_code = l_county_code
3736: and cty.city_name = p_tax_city
3737: and zip.state_code = cty.state_code

Line 3746: from pay_us_city_names cty

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

Line 3756: pay_us_city_names cty

3752: --
3753: cursor csr_valid_zip_code_no_ncty is
3754: select 1
3755: from pay_us_zip_codes zip,
3756: pay_us_city_names cty
3757: where cty.city_name = p_tax_city
3758: and cty.state_code = l_state_code
3759: and zip.state_code = cty.state_code
3760: and zip.city_code = cty.city_code