31: IS
32:
33: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
34: SELECT territory_short_name
35: FROM fnd_territories_vl
36: WHERE territory_code = p_territory_code;
37:
38: l_country fnd_territories_vl.territory_short_name%TYPE;
39:
34: SELECT territory_short_name
35: FROM fnd_territories_vl
36: WHERE territory_code = p_territory_code;
37:
38: l_country fnd_territories_vl.territory_short_name%TYPE;
39:
40: BEGIN
41:
42: IF g_debug THEN