APPS.PAY_CA_CITY_PKG dependencies on PAY_US_CITY_GEOCODES

Line 123: from pay_us_city_geocodes

119:
120: BEGIN
121: select city_code
122: into l_city_code
123: from pay_us_city_geocodes
124: where state_code = l_st_code
125: and county_code = l_county_code
126: and city_code = p_city_code;
127:

Line 161: insert into pay_us_city_geocodes

157: END ;
158:
159: IF lv_new_geo ='Y' THEN
160:
161: insert into pay_us_city_geocodes
162: (state_code,
163: county_code,
164: city_code)
165: values

Line 275: from pay_us_city_geocodes

271: l_cityName pay_us_city_names.city_name%TYPE;
272:
273: CURSOR c_city_code IS
274: select city_code
275: from pay_us_city_geocodes
276: where state_code = l_st_code and county_code = l_co_code
277: and city_code like 'U%';
278:
279: CURSOR zip_exist_c IS

Line 364: from pay_us_city_geocodes

360:
361: /* get number of unknown cities previous entered. */
362: select count(city_code)
363: into l_n_ci_code
364: from pay_us_city_geocodes
365: where state_code = l_st_code and county_code = l_co_code
366: and city_code like 'U%';
367:
368: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);

Line 403: insert into pay_us_city_geocodes

399: hr_utility.trace ('Final city code is:'||l_ci_code);
400: end if;
401: p_ci_code := l_ci_code;
402:
403: insert into pay_us_city_geocodes
404: (state_code, county_code, city_code)
405: values
406: (l_st_code, l_co_code, l_ci_code);
407: hr_utility.trace ('Inserted a geocode.');

Line 521: CURSOR C3 is SELECT rowid from pay_us_city_geocodes

517: AND county_code= p_county_code
518: AND city_code = p_city_code
519: AND city_name = p_city_name;
520: --
521: CURSOR C3 is SELECT rowid from pay_us_city_geocodes
522: WHERE state_code = p_state_code
523: AND county_code= p_county_code
524: AND city_code = p_city_code;
525:

Line 609: CURSOR C3 IS SELECT * FROM pay_us_city_geocodes

605: --
606: CURSOR C2 IS SELECT * FROM pay_us_city_names
607: WHERE rowid = p_cirowid FOR UPDATE OF city_name NOWAIT;
608: --
609: CURSOR C3 IS SELECT * FROM pay_us_city_geocodes
610: WHERE rowid = p_gerowid FOR UPDATE of City_code NOWAIT;
611: --
612: l_recinfo C%ROWTYPE;
613: l_recinfo2 C2%ROWTYPE;

Line 781: -- Deleting from the pay_us_city_geocodes

777: --
778: DELETE FROM pay_us_city_names
779: WHERE rowid = p_cirowid;
780: --
781: -- Deleting from the pay_us_city_geocodes
782: --
783: DELETE FROM pay_us_city_geocodes
784: WHERE rowid = p_gerowid;
785:

Line 783: DELETE FROM pay_us_city_geocodes

779: WHERE rowid = p_cirowid;
780: --
781: -- Deleting from the pay_us_city_geocodes
782: --
783: DELETE FROM pay_us_city_geocodes
784: WHERE rowid = p_gerowid;
785:
786: END IF;
787: --