APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_ALL

Line 36: FROM jtf_terr_all j

32: l_terr_id NUMBER := p_terr_id;
33:
34: CURSOR c_parent_terr_id (p_terr_id IN NUMBER) IS
35: SELECT j.parent_territory_id
36: FROM jtf_terr_all j
37: WHERE j.terr_id = p_terr_id;
38:
39: BEGIN
40:

Line 78: , jtf_terr_all jt2

74: , jt2.num_winners parent_num_winners
75: , jt1.org_id
76: FROM jtf_terr_qtype_usgs_all jtqu
77: , jtf_terr_usgs_all jtu
78: , jtf_terr_all jt2
79: , jtf_terr_all jt1
80: , jtf_qual_type_usgs jqtu
81: WHERE jtqu.terr_id = jt1.terr_id
82: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

Line 79: , jtf_terr_all jt1

75: , jt1.org_id
76: FROM jtf_terr_qtype_usgs_all jtqu
77: , jtf_terr_usgs_all jtu
78: , jtf_terr_all jt2
79: , jtf_terr_all jt1
80: , jtf_qual_type_usgs jqtu
81: WHERE jtqu.terr_id = jt1.terr_id
82: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
83: AND jqtu.qual_type_id = lp_qual_type_id

Line 130: FROM jtf_terr_all jt

126: --
127:
128: AND NOT EXISTS (
129: SELECT jt.terr_id
130: FROM jtf_terr_all jt
131: WHERE ( (NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate) OR
132: (NVL(jt.start_date_active, lp_sysdate - 1) > lp_sysdate) )
133: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
134: START WITH jt.terr_id = jt1.terr_id );

Line 145: , jtf_terr_all jt2

141: , jt1.parent_territory_id
142: , jt2.num_winners parent_num_winners
143: , jt1.org_id
144: FROM jtf_terr_usgs_all jtu
145: , jtf_terr_all jt2
146: , jtf_terr_all jt1
147:
148: WHERE
149: jtu.source_id = lp_source_id

Line 146: , jtf_terr_all jt1

142: , jt2.num_winners parent_num_winners
143: , jt1.org_id
144: FROM jtf_terr_usgs_all jtu
145: , jtf_terr_all jt2
146: , jtf_terr_all jt1
147:
148: WHERE
149: jtu.source_id = lp_source_id
150: AND jtu.terr_id = jt1.terr_id

Line 163: FROM jtf_terr_all jt

159: AND NVL(jt1.start_date_active, lp_sysdate -1) < lp_sysdate
160: AND jt1.parent_territory_id IS NOT NULL
161: AND NOT EXISTS (
162: SELECT jt.terr_id
163: FROM jtf_terr_all jt
164: WHERE ( (NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate) OR
165: (NVL(jt.start_date_active, lp_sysdate - 1) > lp_sysdate) )
166: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
167: START WITH jt.terr_id = jt1.terr_id );

Line 250: , jtf_terr_all j2

246:
247: SELECT /*+ ORDERED */ MAX(j2.rank)
248: INTO l_max_rank
249: FROM jtf_qual_type_usgs j1
250: , jtf_terr_all j2
251: , jtf_terr_qtype_usgs_all j4
252: WHERE ( j2.start_date_active <= l_sysdate AND
253: NVL(j2.end_date_active, l_sysdate) >= l_sysdate)
254: AND j2.terr_id <> 1

Line 334: FROM jtf_terr_all jt

330: AND jqtu.qual_type_id = v.related_id
331: AND v.qual_type_id = p_qual_type_id
332: AND jtq.terr_id IN
333: ( SELECT jt.terr_id
334: FROM jtf_terr_all jt
335: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
336: START WITH jt.terr_id = l_terr_id_tbl(i) );
337:
338: end if; --p_source_id = -1001

Line 373: FROM jtf_terr_all jt

369: IF ( p_source_id <> -1001 ) THEN
370:
371: SELECT jt.terr_id, NVL(jt.num_winners, 1)
372: INTO l_top_level_terr_id_tbl(i), l_num_winners_tbl(i)
373: FROM jtf_terr_all jt
374: WHERE jt.parent_territory_id = 1
375: AND (jt.org_id <> -3114 OR jt.org_id IS NULL)
376: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
377: START WITH jt.terr_id = l_terr_id_tbl(i);

Line 550: FROM jtf_terr_all TR1, jtf_terr_all TR2

546: /* Check for the ancestors */
547: /* JDOCHERT: 06/30/03: bug#3020630 */
548: SELECT DISTINCT TR1.PARENT_TERRITORY_ID, TR2.NUM_WINNERS
549: INTO l_new_parent_territory_id, l_new_parent_num_winners
550: FROM jtf_terr_all TR1, jtf_terr_all TR2
551: WHERE TR2.terr_id = TR1.parent_territory_id
552: AND TR1.TERR_ID <> 1
553: AND TR1.TERR_ID = l_parent_territory_id_tbl(i);
554: