DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_QUAL_ALL

Line 420: , jtf_terr_qual_all jtq

416: AND v.qual_type_id = lp_qual_type_id
417: AND EXISTS ( SELECT jtq.terr_id
418: FROM jtf_terr_qtype_usgs_all jtqu
419: , jtf_terr_all jt
420: , jtf_terr_qual_all jtq
421: , jtf_qual_type_usgs jqtu
422: WHERE NVL(jt.end_date_active, lp_sysdate + 1) > lp_sysdate
423: AND NVL(jt.start_date_active, lp_sysdate - 1) < lp_sysdate
424: AND jtqu.terr_id = jt.terr_id

Line 446: , jtf_terr_qual_all jtq

442: AND EXISTS ( SELECT jtq.terr_id
443: FROM jtf_terr_values_all jtv
444: , jtf_terr_qtype_usgs_all jtqu
445: , jtf_terr_all jt
446: , jtf_terr_qual_all jtq
447: , jtf_qual_type_usgs jqtu
448: WHERE NVL(jt.end_date_active, lp_sysdate + 1) > lp_sysdate
449: AND NVL(jt.start_date_active, lp_sysdate - 1) < lp_sysdate
450: AND jtqu.terr_id = jt.terr_id