APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_COUNTIES

Line 64: p_county_name pay_us_counties.county_name%TYPE;

60: l_emp_city_name pay_us_city_names.city_name%TYPE;
61: l_city_name_found pay_us_city_names.city_name%TYPE;
62: l_city_found VARCHAR2(1):= 'N';
63: l_found_city pay_us_city_names.city_name%TYPE;
64: p_county_name pay_us_counties.county_name%TYPE;
65:
66: cursor c_county_name is
67: select city_name
68: from pay_us_modified_geocodes

Line 78: pay_us_counties puc

74: cursor c_get_emp_cities is
75: select town_or_city
76: from per_addresses pa,
77: pay_us_states pus,
78: pay_us_counties puc
79: where pus.state_abbrev = pa.region_2
80: and pus.state_code = puc.state_code
81: and nvl(p_county_name,puc.county_name) = pa.region_1
82: and pa.person_id = p_person_id

Line 89: pay_us_counties puc

85: union
86: select pa.add_information18
87: from per_addresses pa,
88: pay_us_states pus,
89: pay_us_counties puc
90: where pus.state_abbrev = pa.add_information17
91: and pus.state_code = puc.state_code
92: and nvl(p_county_name,puc.county_name) = pa.add_information19
93: and pa.person_id = p_person_id

Line 100: pay_us_counties puc

96: union
97: select hl.town_or_city
98: from hr_locations_all hl,
99: pay_us_states pus,
100: pay_us_counties puc
101: where pus.state_abbrev = hl.region_2
102: and pus.state_code = puc.state_code
103: and nvl(p_county_name,puc.county_name) = hl.region_1
104: and hl.location_id = p_location_id

Line 111: pay_us_counties puc

107: union
108: select loc_information18
109: from hr_locations_all hl,
110: pay_us_states pus,
111: pay_us_counties puc
112: where pus.state_abbrev = hl.loc_information17
113: and pus.state_code = puc.state_code
114: and nvl(p_county_name,puc.county_name) = hl.loc_information19
115: and pus.state_code = p_state_code

Line 3706: pay_us_counties puc

3702: pumg.city_name old_county_name,
3703: puc.county_name new_county_name
3704: FROM pay_us_modified_geocodes pumg,
3705: pay_us_states pus,
3706: pay_us_counties puc
3707: WHERE pus.state_code = puc.state_code
3708: AND pus.state_code = pumg.state_code
3709: AND puc.county_code = pumg.county_code
3710: AND pumg.patch_name = P_PATCH_NAME

Line 3973: pay_us_counties puc

3969: pumg2.city_name new_city_name
3970: FROM pay_us_modified_geocodes pumg1,
3971: pay_us_modified_geocodes pumg2,
3972: pay_us_states pus,
3973: pay_us_counties puc
3974: WHERE pus.state_code = puc.state_code
3975: AND pus.state_code = pumg1.state_code
3976: AND pus.state_code = pumg2.state_code
3977: AND puc.county_code = pumg1.county_code

Line 3993: CURSOR get_county_name (P_STATE_CODE pay_us_counties.state_code%TYPE,

3989: pus.state_code,
3990: puc.county_code,
3991: pumg1.old_city_code;
3992:
3993: CURSOR get_county_name (P_STATE_CODE pay_us_counties.state_code%TYPE,
3994: P_COUNTY_CODE pay_us_counties.county_code%TYPE) IS
3995: SELECT decode(state_code,'70',county_abbrev,county_name)
3996: FROM pay_us_counties
3997: WHERE state_code = p_state_code

Line 3994: P_COUNTY_CODE pay_us_counties.county_code%TYPE) IS

3990: puc.county_code,
3991: pumg1.old_city_code;
3992:
3993: CURSOR get_county_name (P_STATE_CODE pay_us_counties.state_code%TYPE,
3994: P_COUNTY_CODE pay_us_counties.county_code%TYPE) IS
3995: SELECT decode(state_code,'70',county_abbrev,county_name)
3996: FROM pay_us_counties
3997: WHERE state_code = p_state_code
3998: AND county_code = p_county_code;

Line 3996: FROM pay_us_counties

3992:
3993: CURSOR get_county_name (P_STATE_CODE pay_us_counties.state_code%TYPE,
3994: P_COUNTY_CODE pay_us_counties.county_code%TYPE) IS
3995: SELECT decode(state_code,'70',county_abbrev,county_name)
3996: FROM pay_us_counties
3997: WHERE state_code = p_state_code
3998: AND county_code = p_county_code;
3999:
4000: CURSOR get_new_county_name (P_STATE_CODE pay_us_modified_geocodes.state_code%TYPE,

Line 4010: l_county_name pay_us_counties.county_name%TYPE;

4006: AND county_code = p_county_code
4007: ORDER BY patch_name;
4008:
4009: l_city_name_change get_city_name_changes%ROWTYPE;
4010: l_county_name pay_us_counties.county_name%TYPE;
4011: l_jurisdiction_code pay_us_geo_update.old_juri_code%TYPE;
4012:
4013: BEGIN
4014: