APPS.PER_KAD_BUS dependencies on PAY_US_CITY_NAMES

Line 1471: -- validate town_or_city exist in pay_us_city_names.

1467: -- ---------------------------------------------------------------------------
1468: --
1469: -- Description:
1470: -- If address style is 'US' and Payroll is installed under US legislation,
1471: -- validate town_or_city exist in pay_us_city_names.
1472: --
1473: -- Pre-conditions:
1474: -- Style (p_style) must be valid.
1475: --

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

1481: -- p_object_version_number
1482: --
1483: -- Post Success:
1484: -- If address style is 'US', payroll is installed under US legislation and
1485: -- a row exist in pay_us_city_names for the given town_or_city, processing
1486: -- continues.
1487: --
1488: -- Post Failure:
1489: -- If address style is 'US', payroll is installed under US legislation and

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

1486: -- continues.
1487: --
1488: -- Post Failure:
1489: -- If address style is 'US', payroll is installed under US legislation and
1490: -- a row does not exist in pay_us_city_names for the given town_or_city,
1491: -- an application error is raised and processing terminates.
1492: --
1493: -- Access Status:
1494: -- Internal Table Handler Use Only.

Line 1514: from pay_us_city_names

1510: -- Declare cursor
1511: --
1512: cursor csr_valid_town_or_city is
1513: select null
1514: from pay_us_city_names
1515: where city_name = p_town_or_city;
1516: begin
1517: hr_utility.set_location('Entering:'|| l_proc, 1);
1518: --

Line 1614: l_city_code pay_us_city_names.city_code%TYPE;

1610: --
1611: l_exists varchar2(1);
1612: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';
1613: l_api_updating boolean;
1614: l_city_code pay_us_city_names.city_code%TYPE;
1615: l_state_code pay_us_city_names.state_code%TYPE;
1616: l_postal_code varchar2(6);
1617: l_geocodes_installed varchar2(1); -- 09/12/97 Changed
1618: --

Line 1615: l_state_code pay_us_city_names.state_code%TYPE;

1611: l_exists varchar2(1);
1612: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';
1613: l_api_updating boolean;
1614: l_city_code pay_us_city_names.city_code%TYPE;
1615: l_state_code pay_us_city_names.state_code%TYPE;
1616: l_postal_code varchar2(6);
1617: l_geocodes_installed varchar2(1); -- 09/12/97 Changed
1618: --
1619: cursor csr_valid_city_state is

Line 1621: from pay_us_city_names cty

1617: l_geocodes_installed varchar2(1); -- 09/12/97 Changed
1618: --
1619: cursor csr_valid_city_state is
1620: select cty.city_code, cty.state_code
1621: from pay_us_city_names cty
1622: ,pay_us_states st
1623: where cty.state_code = st.state_code
1624: and st.state_abbrev = p_region_2
1625: and cty.city_name = p_town_or_city;