APPS.OZF_SD_REQUEST_PUB dependencies on JTF_TERR_ALL

Line 2321: JTF_TERR_ALL jt,

2317:
2318: CURSOR c_get_territory (p_terr_id IN VARCHAR2) IS
2319: SELECT 1
2320: FROM JTF_TERR_QTYPE_USGS_ALL jtqu,
2321: JTF_TERR_ALL jt,
2322: JTF_QUAL_TYPE_USGS jqtu
2323: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE)
2324: AND ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE)
2325: OR jt.end_date_active IS NULL ) )