APPS.PA_LOCATION_UTILS dependencies on FND_TERRITORIES

Line 61: FROM fnd_territories_vl

57: l_id_found_flag VARCHAR2(1):= 'N';
58: l_num_ids NUMBER := 0;
59: CURSOR c_ids IS
60: SELECT territory_code
61: FROM fnd_territories_vl
62: WHERE territory_short_name = p_country_name;
63:
64:
65:

Line 72: FROM fnd_territories

68: (p_country_code <> FND_API.G_MISS_CHAR)) THEN
69: IF p_check_id_flag = 'Y' THEN
70: SELECT territory_code
71: INTO x_country_code
72: FROM fnd_territories
73: WHERE territory_code = p_country_code;
74: ---------------------------------------------------
75: -- Added the following code to fix the bug : 1364336
76: -- to validate the LOV based on the user inputs

Line 120: FROM fnd_territories_vl

116: ELSE
117: If p_country_name is NOT NULL then
118: SELECT territory_code
119: INTO x_country_code
120: FROM fnd_territories_vl
121: WHERE territory_short_name = p_country_name;
122:
123: Else
124: x_country_code := NULL;

Line 200: fnd_territories_vl t

196: x_region
197: FROM hr_all_organization_units o, -- Bug 4684196
198: -- hr_organization_units o,
199: hr_locations_all l,
200: fnd_territories_vl t
201: WHERE t.territory_code = l.country
202: AND o.location_id = l.location_id
203: AND o.organization_id = p_organization_id ;
204:

Line 292: fnd_territories_vl t

288: x_country_name,
289: x_city,
290: x_region
291: FROM per_addresses l,
292: fnd_territories_vl t
293: WHERE t.territory_code = l.country
294: AND l.primary_flag = 'Y'
295: AND p_assign_date between l.DATE_FROM and nvl(l.DATE_TO, p_assign_date)
296: AND l.person_id = p_person_id ;

Line 374: fnd_territories_vl t

370: x_country_name,
371: x_city,
372: x_region
373: FROM pa_locations l,
374: fnd_territories_vl t
375: WHERE t.territory_code = l.country_code
376: AND l.location_id = p_location_id ;
377:
378: /* END IF ; */

Line 565: fnd_territories_vl t

561: t.territory_short_name
562: INTO x_country_code,
563: x_country_name
564: FROM pa_locations l,
565: fnd_territories_vl t
566: WHERE t.territory_code = l.country_code
567: AND l.location_id = p_location_id;
568:
569: EXCEPTION