47:
48: -- cursor to get salesreps DELIVERY
49: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
50: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
51: from jtf_terr_resources_v jtrv
52: where jtrv.terr_id = ci_terr_id
53: order by resource_name;
54:
55: -- cursor to get dynamic qualifiers
377:
378: -- cursor to get salesreps DELIVERY
379: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
380: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
381: from jtf_terr_resources_v jtrv
382: where jtrv.terr_id = ci_terr_id
383: order by resource_name;
384:
385: -- cursor to get dynamic qualifiers