APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on FND_TERRITORIES

Line 519: FROM fnd_territories_vl

515: IF (l_country_chk_reqd) THEN
516: BEGIN
517: SELECT territory_short_name
518: INTO l_country_name
519: FROM fnd_territories_vl
520: WHERE territory_code = Xi_country_code;
521: EXCEPTION
522: WHEN no_data_found THEN
523: l_country_name := Xi_country_code;

Line 1203: FROM fnd_territories ft

1199: x_return_status IN OUT NOCOPY VARCHAR2
1200: ) IS
1201: CURSOR c_country IS
1202: SELECT 1
1203: FROM fnd_territories ft
1204: WHERE ft.territory_code = p_country_code;
1205: l_dummy NUMBER(1) := 0;
1206: BEGIN
1207: IF l_DEBUG in ('Y', 'C') THEN