APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_TERRITORIES_VL

Line 1778: from fnd_territories_vl

1774: and configuration_code = p_configuration_code;
1775:
1776: cursor get_country_name(p_territory_code varchar2) IS
1777: select territory_short_name
1778: from fnd_territories_vl
1779: where territory_code = p_territory_code;
1780:
1781: cursor get_selected_list IS
1782: select distinct config_information2

Line 1853: from fnd_territories_vl

1849: and config_information1 = p_reg_var_name;
1850:
1851: cursor get_bg_display_name(p_territory_code varchar2) IS
1852: select territory_short_name
1853: from fnd_territories_vl
1854: where territory_code = p_territory_code;
1855:
1856: l_bg_name varchar2(100);
1857: l_ret_string varchar2(2000);

Line 2048: from fnd_territories_vl

2044: RETURN varchar2 IS
2045:
2046: cursor csr_country(cp_territory_code in varchar2) IS
2047: select territory_short_name
2048: from fnd_territories_vl
2049: where territory_code = p_territory_code;
2050:
2051: l_territory_short_name fnd_territories_vl.territory_short_name%type;
2052: l_proc varchar2(72) := g_package || 'get_country_display_name';

Line 2051: l_territory_short_name fnd_territories_vl.territory_short_name%type;

2047: select territory_short_name
2048: from fnd_territories_vl
2049: where territory_code = p_territory_code;
2050:
2051: l_territory_short_name fnd_territories_vl.territory_short_name%type;
2052: l_proc varchar2(72) := g_package || 'get_country_display_name';
2053: l_error_message varchar2(360);
2054:
2055: BEGIN