APPS.JTF_TERRITORY_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 2367: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu

2363:
2364: UPDATE jtf_terr_ALL jt
2365: SET jt.num_qual = (
2366: SELECT COUNT(jtq.qual_usg_id)
2367: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2368: WHERE jtq.terr_id = jt.terr_id
2369: AND jtq.qual_usg_id = jqu.qual_usg_id
2370: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
2371: AND jqtu.qual_type_id = p_qual_type_id

Line 5641: jtf_qual_type_usgs_ALL jqtu,

5637: ( P_Terr_Qual_Rec.Qual_Usg_Id IS NOT NULL ) Then
5638: /* SELECT 'x'
5639: into l_Temp
5640: from jtf_qual_usgs_ALL jqu,
5641: jtf_qual_type_usgs_ALL jqtu,
5642: jtf_terr_qtype_usgs_ALL jtqu
5643: where jtqu.terr_id = p_Terr_Id and
5644: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5645: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and

Line 6682: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu

6678: l_qual_Type_Usg_id := p_Terr_QualTypeUsgs_Rec.QUAL_TYPE_USG_ID;
6679: --Check the qual_type_usg_id specified is valid
6680: Select 1
6681: into l_dummy
6682: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu
6683: where jtu.terr_id = p_Terr_Id and
6684: jqtu.source_id = jtu.source_id and
6685: jqtu.qual_type_usg_id = l_qual_Type_Usg_id;
6686: