APPS.PER_KAD_BUS dependencies on PAY_US_STATES

Line 1334: -- legislation, or the Vertex pay_us_states table if payroll is installed

1330: --
1331: -- Description:
1332: -- If address style is 'US', validate region_2 code (state abbreviation)
1333: -- exist in the hr_lookups table if HR installation only or non-US
1334: -- legislation, or the Vertex pay_us_states table if payroll is installed
1335: -- under US legislation.
1336: --
1337: -- Pre-conditions:
1338: -- Style (p_style) must be valid.

Line 1349: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states

1345: -- p_effective_date
1346: -- p_object_version_number
1347: --
1348: -- Post Success:
1349: -- If address style is 'US' and a row exist in hr_lookups/pay_us_states
1350: -- for the given region_2 code, processing continues.
1351: --
1352: -- Post Failure:
1353: -- If address style is 'US' and a row does not exist in

Line 1354: -- hr_lookups/pay_us_states for the given region_2 code, an application

1350: -- for the given region_2 code, processing continues.
1351: --
1352: -- Post Failure:
1353: -- If address style is 'US' and a row does not exist in
1354: -- hr_lookups/pay_us_states for the given region_2 code, an application
1355: -- error is raised and processing terminates.
1356: --
1357: -- Access Status:
1358: -- Internal Table Handler Use Only.

Line 1380: from pay_us_states

1376: -- Declare cursor
1377: --
1378: cursor csr_valid_state is
1379: select null
1380: from pay_us_states
1381: where state_abbrev = p_region_2;
1382: --
1383: begin
1384: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1622: ,pay_us_states st

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