APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on FND_TERRITORIES_VL

Line 137: from fnd_territories_vl

133: -- exact match cursor
134: -------------------
135: CURSOR exact_cur IS
136: select territory_code
137: from fnd_territories_vl
138: where upper(territory_short_name) = upper(p_country)
139: and rownum = 1;
140:
141: exact_rec exact_cur%ROWTYPE;

Line 148: from fnd_territories_vl

144: -- fuzzy match cursor
145: -------------------
146: CURSOR fuzzy_count_cur IS
147: select count(1) fuzzy_count
148: from fnd_territories_vl
149: where
150: (
151: upper(territory_short_name) like '%'||upper(p_country)||'%'
152: or

Line 161: from fnd_territories_vl

157: l_fuzzy_count NUMBER := 0;
158:
159: CURSOR fuzzy_cur IS
160: select territory_code
161: from fnd_territories_vl
162: where
163: (
164: upper(territory_short_name) like '%'||upper(p_country)||'%'
165: or

Line 177: from fnd_territories_vl

173: -- extreme fuzzy match cursor
174: -------------------
175: CURSOR extreme_fuzzy_count_cur IS
176: select count(1) extreme_fuzzy_count
177: from fnd_territories_vl
178: where
179: (
180: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
181: or

Line 190: from fnd_territories_vl

186: l_extreme_fuzzy_count NUMBER := 0;
187:
188: CURSOR extreme_fuzzy_cur IS
189: select territory_code
190: from fnd_territories_vl
191: where
192: (
193: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
194: or

Line 206: from fnd_territories_vl

202: -- soundex match cursor
203: -------------------
204: CURSOR soundex_count_cur IS
205: select count(1) soundex_count
206: from fnd_territories_vl
207: where
208: (
209: ap_web_upload_pdm_pkg.mysoundex(upper(territory_short_name)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))
210: or

Line 219: from fnd_territories_vl

215: l_soundex_count NUMBER := 0;
216:
217: CURSOR soundex_cur IS
218: select territory_code
219: from fnd_territories_vl
220: where
221: (
222: ap_web_upload_pdm_pkg.mysoundex(territory_short_name) = ap_web_upload_pdm_pkg.mysoundex(p_country)
223: or