APPS.PAY_US_CITY_PKG dependencies on PAY_US_STATES

Line 121: l_st_code pay_us_states.state_code%TYPE;

117: -- Define Local Variables to hold local information
118:
119: l_zip_start pay_us_zip_codes.zip_start%TYPE;
120: l_zip_end pay_us_zip_codes.zip_end%TYPE;
121: l_st_code pay_us_states.state_code%TYPE;
122: l_st_abbrev pay_us_states.state_abbrev%TYPE;
123: l_state_Name pay_us_states.state_name%TYPE;
124: l_county_code pay_us_counties.county_code%TYPE;
125: l_county_Name pay_us_counties.county_name%TYPE;

Line 122: l_st_abbrev pay_us_states.state_abbrev%TYPE;

118:
119: l_zip_start pay_us_zip_codes.zip_start%TYPE;
120: l_zip_end pay_us_zip_codes.zip_end%TYPE;
121: l_st_code pay_us_states.state_code%TYPE;
122: l_st_abbrev pay_us_states.state_abbrev%TYPE;
123: l_state_Name pay_us_states.state_name%TYPE;
124: l_county_code pay_us_counties.county_code%TYPE;
125: l_county_Name pay_us_counties.county_name%TYPE;
126: l_city_code pay_us_city_names.city_code%TYPE;

Line 123: l_state_Name pay_us_states.state_name%TYPE;

119: l_zip_start pay_us_zip_codes.zip_start%TYPE;
120: l_zip_end pay_us_zip_codes.zip_end%TYPE;
121: l_st_code pay_us_states.state_code%TYPE;
122: l_st_abbrev pay_us_states.state_abbrev%TYPE;
123: l_state_Name pay_us_states.state_name%TYPE;
124: l_county_code pay_us_counties.county_code%TYPE;
125: l_county_Name pay_us_counties.county_name%TYPE;
126: l_city_code pay_us_city_names.city_code%TYPE;
127: l_city_Name pay_us_city_names.city_name%TYPE;

Line 148: from pay_us_states

144:
145: BEGIN
146: select state_code, state_abbrev
147: into l_st_code, l_st_abbrev
148: from pay_us_states
149: where state_name = l_state_Name;
150:
151: EXCEPTION WHEN no_data_found THEN
152: hr_utility.trace ('Error: Failed to find state codes.');

Line 315: l_st_code pay_us_states.state_code%TYPE;

311: l_n_ci_name number := 0;
312:
313: l_zip_start pay_us_zip_codes.zip_start%TYPE;
314: l_zip_end pay_us_zip_codes.zip_end%TYPE;
315: l_st_code pay_us_states.state_code%TYPE;
316: l_st_abbrev pay_us_states.state_abbrev%TYPE;
317: l_stateName pay_us_states.state_name%TYPE;
318: l_co_code pay_us_counties.county_code%TYPE;
319: l_countyName pay_us_counties.county_name%TYPE;

Line 316: l_st_abbrev pay_us_states.state_abbrev%TYPE;

312:
313: l_zip_start pay_us_zip_codes.zip_start%TYPE;
314: l_zip_end pay_us_zip_codes.zip_end%TYPE;
315: l_st_code pay_us_states.state_code%TYPE;
316: l_st_abbrev pay_us_states.state_abbrev%TYPE;
317: l_stateName pay_us_states.state_name%TYPE;
318: l_co_code pay_us_counties.county_code%TYPE;
319: l_countyName pay_us_counties.county_name%TYPE;
320: l_ci_code pay_us_city_names.city_code%TYPE;

Line 317: l_stateName pay_us_states.state_name%TYPE;

313: l_zip_start pay_us_zip_codes.zip_start%TYPE;
314: l_zip_end pay_us_zip_codes.zip_end%TYPE;
315: l_st_code pay_us_states.state_code%TYPE;
316: l_st_abbrev pay_us_states.state_abbrev%TYPE;
317: l_stateName pay_us_states.state_name%TYPE;
318: l_co_code pay_us_counties.county_code%TYPE;
319: l_countyName pay_us_counties.county_name%TYPE;
320: l_ci_code pay_us_city_names.city_code%TYPE;
321: l_cityName pay_us_city_names.city_name%TYPE;

Line 364: from pay_us_states

360:
361: BEGIN
362: select state_code, state_abbrev
363: into l_st_code, l_st_abbrev
364: from pay_us_states
365: where state_name = l_stateName;
366:
367: EXCEPTION WHEN no_data_found THEN
368: hr_utility.trace ('Error: Failed to find state codes.');