58: TERR_ID,
59: QUAL_USG_ID,
60: ORG_ID,
61: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
62: FROM jtf_terr_qualifiers_v
63: WHERE terr_id = p_template_terr_id;
64:
65: -- cursor to get values for dynamic qualifier values
66: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
388: TERR_ID,
389: QUAL_USG_ID,
390: ORG_ID,
391: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
392: FROM jtf_terr_qualifiers_v
393: WHERE terr_id = p_template_terr_id;
394:
395: -- cursor to get values for dynamic qualifier values
396: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS