APPS.JTF_TERRITORY_PVT dependencies on JTF_QUAL_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 5640: from jtf_qual_usgs_ALL jqu,

5636: IF ( p_Terr_Id IS NOT NULL ) AND
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

Line 5656: jtf_qual_usgs_all jqua

5652: SELECT 'x'
5653: INTO l_Temp
5654: FROM jtf_terr_all jta,
5655: jtf_terr_type_qual_all jtqa,
5656: jtf_qual_usgs_all jqua
5657: WHERE jta.terr_id = p_Terr_Id
5658: AND jta.territory_type_id = jtqa.terr_type_id
5659: AND jtqa.qual_usg_id = jqua.qual_usg_id
5660: AND jqua.org_id = jtqa.org_id

Line 6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq

6919: jqu.display_sql1,
6920: jqu.display_sql2,
6921: jqu.display_sql3,
6922: html_lov_sql1
6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq
6924: where jqu.qual_usg_id = jtq.qual_Usg_Id and
6925: jqu.org_id = jtq.org_id AND
6926: jtq.terr_qual_id = p_Terr_Qual_Id;
6927: