APPS.OZF_QP_QUAL_PVT dependencies on JTF_TERR_QTYPE_USGS

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

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

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

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

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

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

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

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