APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 76: FROM jtf_terr_qtype_usgs_all jtqu

72: , jt1.num_winners
73: , jt1.parent_territory_id
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

Line 251: , jtf_terr_qtype_usgs_all j4

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
255: -- EIHSU: 09/27/02: bug#2590004

Line 312: /* ARPATEL: 12/03/2003: For Oracle Sales num_qual is now stored in jtf_terr_qtype_usgs_all */

308:
309: l_num_qual_tbl.EXTEND;
310:
311: /* TOTAL number of qualifiers */
312: /* ARPATEL: 12/03/2003: For Oracle Sales num_qual is now stored in jtf_terr_qtype_usgs_all */
313: if p_source_id = -1001
314: then
315: l_num_qual_tbl(i) := 0;
316: else