APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_CITY_NAMES

Line 60: l_emp_city_name pay_us_city_names.city_name%TYPE;

56: p_process_type varchar2
57: )
58: return varchar2 is
59:
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;

Line 61: l_city_name_found pay_us_city_names.city_name%TYPE;

57: )
58: return varchar2 is
59:
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:

Line 63: l_found_city pay_us_city_names.city_name%TYPE;

59:
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

Line 119: cursor c_get_city_names(p_emp_city_name pay_us_city_names.city_name%TYPE) is

115: and pus.state_code = p_state_code
116: and puc.county_code = p_county_code
117: and hl.location_id = p_location_id;
118:
119: cursor c_get_city_names(p_emp_city_name pay_us_city_names.city_name%TYPE) is
120: select pucn.city_name
121: from pay_us_city_names pucn
122: where pucn.state_code = p_state_code
123: and pucn.county_code = p_county_code

Line 121: from pay_us_city_names pucn

117: and hl.location_id = p_location_id;
118:
119: cursor c_get_city_names(p_emp_city_name pay_us_city_names.city_name%TYPE) is
120: select pucn.city_name
121: from pay_us_city_names pucn
122: where pucn.state_code = p_state_code
123: and pucn.county_code = p_county_code
124: and pucn.city_code = p_city_code
125: and pucn.city_name = p_emp_city_name

Line 134: from pay_us_city_names pucn,

130: and new_city_code = p_city_code
131: and old_city_code <> p_city_code)
132: union
133: select pucn.city_name
134: from pay_us_city_names pucn,
135: pay_us_modified_geocodes pumg
136: where pucn.state_code = p_state_code
137: and pucn.county_code = p_county_code
138: and pucn.city_name = p_emp_city_name

Line 3898: City Name delivered in PAY_US_CITY_NAMES gets copied into other tables as

3894:
3895: /* Added for Annual GEO 2012 for Bug#14314081
3896:
3897: This Procedure is added to take care of the City Name changes delivered. The
3898: City Name delivered in PAY_US_CITY_NAMES gets copied into other tables as
3899: it is used in Person Address or Location Address etc. Since we are changing
3900: the City Name we delivered earlier, it is necessary to update the City Name
3901: details stored in other tables.
3902: