[Home] [Help]
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
84: AND jtu.source_id = lp_source_id
245: BEGIN
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)
317: SELECT count(*)
318: INTO l_num_qual_tbl(i)
319: FROM jtf_terr_qual_all jtq
320: , jtf_qual_usgs_all jqu
321: , jtf_qual_type_usgs jqtu
322: , jtf_qual_type_denorm_v v
323: WHERE jtq.qual_usg_id = jqu.qual_usg_id
324: AND ( (jtq.org_id = jqu.org_id) OR
325: (jtq.org_id IS NULL AND jqu.org_ID IS NULL)
649: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
650: WHERE o.terr_qual_id IN (
651: SELECT /*+ INDEX (i2 jtf_qual_usgs_n1) */
652: i1.terr_qual_id
653: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
654: WHERE i1.qual_usg_id = i2.qual_usg_id
655: AND i2.display_type = 'CHAR'
656: AND i2.lov_sql IS NULL
657: AND i2.org_id = -3113