APPS.JTF_TERR_DEFINITION_REPORT_PVT dependencies on JTF_TERR_QUAL

Line 40: from jtf_terr_rsc jtr, jtf_terr_qual jtq --, jtf_terr_usgs jtu

36: where NVL(j.end_date_active, sysdate) >= sysdate
37: AND j.start_date_active <= sysdate
38: AND EXISTS
39: ( select jtr.terr_id
40: from jtf_terr_rsc jtr, jtf_terr_qual jtq --, jtf_terr_usgs jtu
41: where jtr.terr_id = jtq.terr_id
42: and jtr.resource_id = decode(l_srp,-1,jtr.resource_id,l_srp)
43: and jtq.qual_usg_id = decode(l_qual, -1, jtq.qual_usg_id, l_qual)
44: --and jtu.source_id = decode(l_usg, -1, jtu.source_id, l_usg)

Line 62: FROM jtf_terr_qualifiers_v

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

Line 373: (select jtr.terr_id from jtf_terr_rsc jtr, jtf_terr_qual jtq

369: -- cursor of result territory searches with resource and qualifier restrictions
370: CURSOR cur_terr is
371: select terr_id, wf_notification.substitutespecialchars(name) name, rank from jtf_terr_all
372: where terr_id in
373: (select jtr.terr_id from jtf_terr_rsc jtr, jtf_terr_qual jtq
374: where jtr.terr_id = jtq.terr_id
375: and jtr.resource_id = decode(l_srp,-1,jtr.resource_id,l_srp)
376: and jtq.qual_usg_id = decode(l_qual, -1, jtq.qual_usg_id, l_qual));
377:

Line 392: FROM jtf_terr_qualifiers_v

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