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.PAY_CA_CITY_PKG dependencies on PAY_US_STATES

Line 71: l_st_code pay_us_states.state_code%TYPE;

67: -- Define Local Variables to hold local information
68:
69: l_zip_start pay_us_zip_codes.zip_start%TYPE;
70: l_zip_end pay_us_zip_codes.zip_end%TYPE;
71: l_st_code pay_us_states.state_code%TYPE;
72: l_st_abbrev pay_us_states.state_abbrev%TYPE;
73: l_state_Name pay_us_states.state_name%TYPE;
74: l_county_code pay_us_counties.county_code%TYPE;
75: l_county_Name pay_us_counties.county_name%TYPE;

Line 72: l_st_abbrev pay_us_states.state_abbrev%TYPE;

68:
69: l_zip_start pay_us_zip_codes.zip_start%TYPE;
70: l_zip_end pay_us_zip_codes.zip_end%TYPE;
71: l_st_code pay_us_states.state_code%TYPE;
72: l_st_abbrev pay_us_states.state_abbrev%TYPE;
73: l_state_Name pay_us_states.state_name%TYPE;
74: l_county_code pay_us_counties.county_code%TYPE;
75: l_county_Name pay_us_counties.county_name%TYPE;
76: l_city_code pay_us_city_names.city_code%TYPE;

Line 73: l_state_Name pay_us_states.state_name%TYPE;

69: l_zip_start pay_us_zip_codes.zip_start%TYPE;
70: l_zip_end pay_us_zip_codes.zip_end%TYPE;
71: l_st_code pay_us_states.state_code%TYPE;
72: l_st_abbrev pay_us_states.state_abbrev%TYPE;
73: l_state_Name pay_us_states.state_name%TYPE;
74: l_county_code pay_us_counties.county_code%TYPE;
75: l_county_Name pay_us_counties.county_name%TYPE;
76: l_city_code pay_us_city_names.city_code%TYPE;
77: l_city_Name pay_us_city_names.city_name%TYPE;

Line 98: from pay_us_states

94:
95: BEGIN
96: select state_code, state_abbrev
97: into l_st_code, l_st_abbrev
98: from pay_us_states
99: where state_name = l_state_Name;
100:
101: EXCEPTION WHEN no_data_found THEN
102: hr_utility.trace ('Error: Failed to find state codes.');

Line 265: l_st_code pay_us_states.state_code%TYPE;

261: l_n_ci_name number := 0;
262:
263: l_zip_start pay_us_zip_codes.zip_start%TYPE;
264: l_zip_end pay_us_zip_codes.zip_end%TYPE;
265: l_st_code pay_us_states.state_code%TYPE;
266: l_st_abbrev pay_us_states.state_abbrev%TYPE;
267: l_stateName pay_us_states.state_name%TYPE;
268: l_co_code pay_us_counties.county_code%TYPE;
269: l_countyName pay_us_counties.county_name%TYPE;

Line 266: l_st_abbrev pay_us_states.state_abbrev%TYPE;

262:
263: l_zip_start pay_us_zip_codes.zip_start%TYPE;
264: l_zip_end pay_us_zip_codes.zip_end%TYPE;
265: l_st_code pay_us_states.state_code%TYPE;
266: l_st_abbrev pay_us_states.state_abbrev%TYPE;
267: l_stateName pay_us_states.state_name%TYPE;
268: l_co_code pay_us_counties.county_code%TYPE;
269: l_countyName pay_us_counties.county_name%TYPE;
270: l_ci_code pay_us_city_names.city_code%TYPE;

Line 267: l_stateName pay_us_states.state_name%TYPE;

263: l_zip_start pay_us_zip_codes.zip_start%TYPE;
264: l_zip_end pay_us_zip_codes.zip_end%TYPE;
265: l_st_code pay_us_states.state_code%TYPE;
266: l_st_abbrev pay_us_states.state_abbrev%TYPE;
267: l_stateName pay_us_states.state_name%TYPE;
268: l_co_code pay_us_counties.county_code%TYPE;
269: l_countyName pay_us_counties.county_name%TYPE;
270: l_ci_code pay_us_city_names.city_code%TYPE;
271: l_cityName pay_us_city_names.city_name%TYPE;

Line 314: from pay_us_states

310:
311: BEGIN
312: select state_code, state_abbrev
313: into l_st_code, l_st_abbrev
314: from pay_us_states
315: where state_name = l_stateName;
316:
317: EXCEPTION WHEN no_data_found THEN
318: hr_utility.trace ('Error: Failed to find state codes.');