APPS.PAY_CA_CITY_UPD dependencies on PAY_CA_DISPLAY_CITIES

Line 81: FROM pay_ca_display_cities;

77: SELECT city_name,
78: county_code,
79: city_code,
80: display_city_name
81: FROM pay_ca_display_cities;
82:
83: CURSOR duplicate_cities IS
84: SELECT DISTINCT
85: pdc1.display_city_name,

Line 90: FROM pay_ca_display_cities pdc1,

86: pdc1.city_name,
87: pdc1.county_code,
88: pdc1.city_code,
89: pcn.primary_flag
90: FROM pay_ca_display_cities pdc1,
91: pay_ca_display_cities pdc2,
92: pay_us_city_names pcn
93: WHERE pdc1.city_code = pdc2.city_code
94: AND pdc1.county_code = pdc2.county_code

Line 91: pay_ca_display_cities pdc2,

87: pdc1.county_code,
88: pdc1.city_code,
89: pcn.primary_flag
90: FROM pay_ca_display_cities pdc1,
91: pay_ca_display_cities pdc2,
92: pay_us_city_names pcn
93: WHERE pdc1.city_code = pdc2.city_code
94: AND pdc1.county_code = pdc2.county_code
95: AND pdc1.display_city_name = pdc2.display_city_name

Line 108: pay_ca_display_cities pdc

104: SELECT pdc.city_name,
105: pdc.county_code,
106: pdc.city_code
107: FROM pay_us_city_names pcn,
108: pay_ca_display_cities pdc
109: WHERE pcn.state_code = '70'
110: AND pcn.county_code = pdc.county_code
111: AND pcn.city_code = pdc.city_code
112: AND pcn.city_name = pdc.display_city_name;

Line 156: hr_utility.trace('Loaded all duplicate city name mappings from pay_ca_display_cities');

152: v_dup_primary_flag;
153:
154: CLOSE duplicate_cities;
155:
156: hr_utility.trace('Loaded all duplicate city name mappings from pay_ca_display_cities');
157:
158: IF v_dup_new_city.COUNT > 0 THEN
159:
160: FOR j IN v_dup_new_city.first..v_dup_new_city.last LOOP

Line 220: hr_utility.trace('Loaded batch of city name mappings from pay_ca_display_cities');

216: v_rows_in_collect := v_new_row_count - v_old_row_count;
217:
218: EXIT WHEN (v_rows_in_collect = 0);
219:
220: hr_utility.trace('Loaded batch of city name mappings from pay_ca_display_cities');
221:
222: IF v_old_city.COUNT > 0 THEN
223:
224: FOR j IN v_old_city.first..v_old_city.last LOOP