APPS.PER_FI_POPULATE_COUNTRIES dependencies on FND_TERRITORIES_VL

Line 11: -- Cursor for fetching territory_short_name from fnd_territories_vl.

7: (p_errbuf OUT nocopy VARCHAR2
8: ,p_retcode OUT nocopy NUMBER
9: ,p_business_group_id IN NUMBER )
10: AS
11: -- Cursor for fetching territory_short_name from fnd_territories_vl.
12: --
13: CURSOR c_territory (p_bg NUMBER,p_table_id NUMBER) IS
14: SELECT TERRITORY_CODE||' - '||territory_short_name territory_short_name
15: FROM fnd_territories_vl

Line 15: FROM fnd_territories_vl

11: -- Cursor for fetching territory_short_name from fnd_territories_vl.
12: --
13: CURSOR c_territory (p_bg NUMBER,p_table_id NUMBER) IS
14: SELECT TERRITORY_CODE||' - '||territory_short_name territory_short_name
15: FROM fnd_territories_vl
16: WHERE UPPER(TERRITORY_CODE||' - '||territory_short_name) NOT IN
17: ( SELECT UPPER(row_low_range_or_name)
18: FROM pay_user_rows_f
19: WHERE user_table_id=p_table_id

Line 34: FROM fnd_territories_vl );

30: WHERE user_table_id=p_table_id
31: AND business_group_id = p_bg
32: AND UPPER(row_low_range_or_name) IN
33: (SELECT UPPER(territory_short_name)
34: FROM fnd_territories_vl );
35:
36: CURSOR c_chk_territory(p_row_low_range_or_name VARCHAR2 ) IS
37: SELECT UPPER(TERRITORY_CODE||' - '||territory_short_name) territory_short_name
38: FROM fnd_territories_vl

Line 38: FROM fnd_territories_vl

34: FROM fnd_territories_vl );
35:
36: CURSOR c_chk_territory(p_row_low_range_or_name VARCHAR2 ) IS
37: SELECT UPPER(TERRITORY_CODE||' - '||territory_short_name) territory_short_name
38: FROM fnd_territories_vl
39: WHERE UPPER(territory_short_name) = p_row_low_range_or_name ;
40:
41:
42: