APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_TYPE_USGS_ALL
Line 1371: jtf_terr_type_usgs_all b
1367: BEGIN
1368: SELECT 1
1369: INTO l_dummy
1370: FROM jtf_terr_types_all a, 1371: jtf_terr_type_usgs_all b 1372: WHERE a.enabled_flag = 'Y'
1373: AND a.terr_type_id = b.terr_type_id
1374: AND a.org_id = b.org_id
1375: AND b.source_id = p_terr_usgs_tbl (1).source_id