APPS.AS_TAP_PURGE_PUB dependencies on JTF_TERR_ALL
Line 29: from JTF_TERR_ALL terr
25: rowid,access_id
26: from AS_TERRITORY_ACCESSES
27: where not exists
28: (select 1 29: from JTF_TERR_ALL terr 30: where AS_TERRITORY_ACCESSES.TERRITORY_ID = terr.TERR_ID
31: and sysdate between terr.start_date_active and
32: terr.end_date_active) ;
33: