APPS.PAY_US_CITY_PKG dependencies on PAY_US_CITY_GEOCODES

Line 173: from pay_us_city_geocodes

169:
170: BEGIN
171: select city_code
172: into l_city_code
173: from pay_us_city_geocodes
174: where state_code = l_st_code
175: and county_code = l_county_code
176: and city_code = p_city_code;
177:

Line 211: insert into pay_us_city_geocodes

207: END ;
208:
209: IF lv_new_geo ='Y' THEN
210:
211: insert into pay_us_city_geocodes
212: (state_code,
213: county_code,
214: city_code)
215: values

Line 325: from pay_us_city_geocodes

321: l_cityName pay_us_city_names.city_name%TYPE;
322:
323: CURSOR c_city_code IS
324: select city_code
325: from pay_us_city_geocodes
326: where state_code = l_st_code and county_code = l_co_code
327: and city_code like 'U%';
328:
329: CURSOR zip_exist_c IS

Line 414: from pay_us_city_geocodes

410:
411: /* get number of unknown cities previous entered. */
412: select count(city_code)
413: into l_n_ci_code
414: from pay_us_city_geocodes
415: where state_code = l_st_code and county_code = l_co_code
416: and city_code like 'U%';
417:
418: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);

Line 453: insert into pay_us_city_geocodes

449: hr_utility.trace ('Final city code is:'||l_ci_code);
450: end if;
451: p_ci_code := l_ci_code;
452:
453: insert into pay_us_city_geocodes
454: (state_code, county_code, city_code)
455: values
456: (l_st_code, l_co_code, l_ci_code);
457: hr_utility.trace ('Inserted a geocode.');

Line 571: CURSOR C3 is SELECT rowid from pay_us_city_geocodes

567: AND county_code= p_county_code
568: AND city_code = p_city_code
569: AND city_name = p_city_name;
570: --
571: CURSOR C3 is SELECT rowid from pay_us_city_geocodes
572: WHERE state_code = p_state_code
573: AND county_code= p_county_code
574: AND city_code = p_city_code;
575:

Line 659: CURSOR C3 IS SELECT * FROM pay_us_city_geocodes

655: --
656: CURSOR C2 IS SELECT * FROM pay_us_city_names
657: WHERE rowid = p_cirowid FOR UPDATE OF city_name NOWAIT;
658: --
659: CURSOR C3 IS SELECT * FROM pay_us_city_geocodes
660: WHERE rowid = p_gerowid FOR UPDATE of City_code NOWAIT;
661: --
662: l_recinfo C%ROWTYPE;
663: l_recinfo2 C2%ROWTYPE;

Line 831: -- Deleting from the pay_us_city_geocodes

827: --
828: DELETE FROM pay_us_city_names
829: WHERE rowid = p_cirowid;
830: --
831: -- Deleting from the pay_us_city_geocodes
832: --
833: DELETE FROM pay_us_city_geocodes
834: WHERE rowid = p_gerowid;
835:

Line 833: DELETE FROM pay_us_city_geocodes

829: WHERE rowid = p_cirowid;
830: --
831: -- Deleting from the pay_us_city_geocodes
832: --
833: DELETE FROM pay_us_city_geocodes
834: WHERE rowid = p_gerowid;
835:
836: END IF;
837: --