APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 4275: FROM JTF_TERR_RSC_ACCESS_ALL JTRA

4271: AND NVL(jt.end_date_active, sysdate+1) > sysdate
4272: AND NVL(jt.start_date_active, sysdate-1) < sysdate
4273: AND EXISTS (
4274: SELECT 1
4275: FROM JTF_TERR_RSC_ACCESS_ALL JTRA
4276: WHERE JTRA.terr_rsc_id = JTR.terr_rsc_id
4277: AND JTRA.trans_access_code = 'ESC_OWNER');
4278:
4279: