APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_QUAL_TYPE_USGS

Line 4865: jtf_qual_type_usgs jqtu,

4861: THEN
4862: SELECT 'x'
4863: INTO l_temp
4864: FROM jtf_qual_usgs jqu,
4865: jtf_qual_type_usgs jqtu,
4866: jtf_type_qtype_usgs jtqu
4867: WHERE jtqu.terr_type_id = p_terr_type_id
4868: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
4869: AND jqu.qual_usg_id = p_terrtypequal_rec.qual_usg_id

Line 5230: FROM jtf_terr_type_usgs jtu, jtf_qual_type_usgs jqtu

5226: l_qual_type_usg_id := p_type_qualtypeusgs_rec.qual_type_usg_id;
5227: --Check the qual_type_usg_id specified is valid
5228: SELECT 1
5229: INTO l_dummy
5230: FROM jtf_terr_type_usgs jtu, jtf_qual_type_usgs jqtu
5231: WHERE jtu.terr_type_id = p_terr_type_id
5232: AND jtu.source_id = jqtu.source_id
5233: AND jqtu.qual_type_usg_id = l_qual_type_usg_id;
5234: EXCEPTION