APPS.OZF_QP_QUAL_PVT dependencies on JTF_QUAL_TYPE_USGS

Line 404: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu

400:
401: CURSOR cur_is_terr_setup IS
402: SELECT /*+ ORDERED */ -- julou sql performance fix
403: count(*)
404: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu
405: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
406: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
407: jt.end_date_active IS NULL ))
408: AND jt.terr_id = jtqu.terr_id

Line 757: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu, jtf_qual_type_usgs jqtu

753: */
754: CURSOR cur_is_terr_setup IS
755: SELECT /*+ ORDERED */ -- julou sql performance fix
756: count(*)
757: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu, jtf_qual_type_usgs jqtu
758: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
759: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
760: jt.end_date_active IS NULL ))
761: AND jt.terr_id = jtqu.terr_id

Line 1110: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu

1106:
1107: CURSOR cur_is_terr_setup IS
1108: SELECT /*+ ORDERED */ -- julou sql performance fix
1109: count(*)
1110: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu
1111: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
1112: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
1113: jt.end_date_active IS NULL ))
1114: AND jt.terr_id = jtqu.terr_id

Line 1442: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu,jtf_qual_type_usgs jqtu

1438:
1439: CURSOR cur_is_terr_setup IS
1440: SELECT /*+ ORDERED */ -- julou sql performance fix
1441: count(*)
1442: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu,jtf_qual_type_usgs jqtu
1443: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
1444: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
1445: jt.end_date_active IS NULL ))
1446: AND jt.terr_id = jtqu.terr_id