403:
404: CURSOR cur_is_terr_setup IS
405: SELECT /*+ ORDERED */ -- julou sql performance fix
406: count(*)
407: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu
408: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
409: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
410: jt.end_date_active IS NULL ))
411: AND jt.terr_id = jtqu.terr_id
1109:
1110: CURSOR cur_is_terr_setup IS
1111: SELECT /*+ ORDERED */ -- julou sql performance fix
1112: count(*)
1113: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu
1114: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
1115: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
1116: jt.end_date_active IS NULL ))
1117: AND jt.terr_id = jtqu.terr_id