1220: IS
1221:
1222: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
1223: SELECT territory_short_name
1224: FROM fnd_territories_vl
1225: WHERE territory_code = p_territory_code;
1226:
1227: l_country fnd_territories_vl.territory_short_name%TYPE;
1228:
1223: SELECT territory_short_name
1224: FROM fnd_territories_vl
1225: WHERE territory_code = p_territory_code;
1226:
1227: l_country fnd_territories_vl.territory_short_name%TYPE;
1228:
1229: BEGIN
1230:
1231: IF g_debug THEN