APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_QUAL_TYPE_USGS

Line 3701: , jtf_qual_type_usgs jqtu

3697: SELECT 'TRUE'
3698: FROM jtf_terr_qtype_usgs_all jtqu
3699: , jtf_terr_usgs_all jtu
3700: , jtf_terr_all jt1
3701: , jtf_qual_type_usgs jqtu
3702: WHERE jtqu.terr_id = jt1.terr_id
3703: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
3704: AND jqtu.qual_type_id = lp_qual_type_id
3705: AND jtu.source_id = lp_source_id

Line 3743: , jtf_qual_type_usgs jqtu

3739: SELECT jtqu.terr_id
3740: , jtqu.terr_qtype_usg_id
3741: FROM jtf_terr_qtype_usgs_all jtqu
3742: , jtf_terr_denorm_rules_all jtdr
3743: , jtf_qual_type_usgs jqtu
3744: WHERE jqtu.qual_type_id = LP_qual_type_id
3745: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
3746: AND jtqu.terr_id = jtdr.terr_id
3747: AND jtdr.resource_exists_flag = 'Y'

Line 3769: FROM jtf_qual_type_usgs jqtu, jtf_qual_types jqt

3765: AND jtdr.source_id = lp_source_id;
3766:
3767: CURSOR csr_get_transactions(lp_source_id NUMBER) IS
3768: SELECT jqt.qual_type_id
3769: FROM jtf_qual_type_usgs jqtu, jtf_qual_types jqt
3770: WHERE jqtu.qual_type_id = jqt.qual_type_id
3771: AND jqt.qual_type_id <> -1001
3772: AND jqtu.source_id = lp_source_id;
3773:

Line 4073: , jtf_qual_type_usgs jqtu

4069: SET qua.num_qual = (
4070: SELECT COUNT(*)
4071: FROM jtf_terr_qual_all jtq
4072: , jtf_qual_usgs_all jqu
4073: , jtf_qual_type_usgs jqtu
4074: , jtf_qual_type_denorm_v v
4075: WHERE jtq.qual_usg_id = jqu.qual_usg_id
4076: /* ACHANDA 03/08/2004 : Bug 3378530 : change the where clause to use index more selectively */
4077: AND jqu.org_id = -3113

Line 4327: , jtf_qual_type_usgs jqtu

4323: UPDATE jtf_terr_qtype_usgs_all qua
4324: SET qua.num_qual = ( SELECT count(*)
4325: FROM jtf_terr_qual_all jtq
4326: , jtf_qual_usgs_all jqu
4327: , jtf_qual_type_usgs jqtu
4328: , jtf_qual_type_denorm_v v
4329: WHERE jtq.qual_usg_id = jqu.qual_usg_id
4330: /* ACHANDA 02/03/2004 : Bug 3378530 : change the where clause to use index more selectively */
4331: AND jqu.org_id = -3113