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_US_CITY_PKG dependencies on PAY_US_COUNTIES

Line 124: l_county_code pay_us_counties.county_code%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;
128: lv_city_Name pay_us_city_names.city_name%TYPE;

Line 125: l_county_Name pay_us_counties.county_name%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;
128: lv_city_Name pay_us_city_names.city_name%TYPE;
129:

Line 160: from pay_us_counties

156:
157: BEGIN
158: select county_code
159: into l_county_code
160: from pay_us_counties
161: where state_code = l_st_code
162: and initcap(county_name) = l_county_Name;
163:
164: EXCEPTION WHEN no_data_found THEN

Line 318: l_co_code pay_us_counties.county_code%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;
322:

Line 319: l_countyName pay_us_counties.county_name%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;
322:
323: CURSOR c_city_code IS

Line 378: from pay_us_counties

374:
375: BEGIN
376: select county_code
377: into l_co_code
378: from pay_us_counties
379: where state_code = l_st_code
380: and initcap(county_name) = l_countyName;
381:
382: EXCEPTION WHEN no_data_found THEN

Line 904: FROM pay_us_counties

900: IF p_state_abbrev = 'CN' THEN
901:
902: SELECT county_abbrev
903: INTO l_prov_abbrev
904: FROM pay_us_counties
905: WHERE county_name = p_county_name
906: AND state_code = '70';
907:
908: OPEN C1;