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_COUNTIES

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

Line 75: l_county_Name pay_us_counties.county_name%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;
78: lv_city_Name pay_us_city_names.city_name%TYPE;
79:

Line 110: from pay_us_counties

106:
107: BEGIN
108: select county_code
109: into l_county_code
110: from pay_us_counties
111: where state_code = l_st_code
112: and initcap(county_name) = l_county_Name;
113:
114: EXCEPTION WHEN no_data_found THEN

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

Line 269: l_countyName pay_us_counties.county_name%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;
272:
273: CURSOR c_city_code IS

Line 328: from pay_us_counties

324:
325: BEGIN
326: select county_code
327: into l_co_code
328: from pay_us_counties
329: where state_code = l_st_code
330: and initcap(county_name) = l_countyName;
331:
332: EXCEPTION WHEN no_data_found THEN

Line 854: FROM pay_us_counties

850: IF p_state_abbrev = 'CN' THEN
851:
852: SELECT county_abbrev
853: INTO l_prov_abbrev
854: FROM pay_us_counties
855: WHERE county_name = p_county_name
856: AND state_code = '70';
857:
858: OPEN C1;