APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 4266: JTF_TERR_RSC_ACCESS_ALL JTRA,

4262: JTR.ROLE,
4263: decode(JTRA.trans_access_code, 'ESC_OWNER', 'Y', 'ESCALATION', 'N', 'N') PRIMARY_CONTACT_FLAG
4264: --JTR.PRIMARY_CONTACT_FLAG
4265: From JTF_TERR_RSC_ALL JTR,
4266: JTF_TERR_RSC_ACCESS_ALL JTRA,
4267: JTF_TERR_ALL JT
4268: Where JT.TERR_ID = p_Terr_id
4269: AND JTR.TERR_ID = JT.TERR_ID
4270: AND JTR.TERR_RSC_ID = JTRA.TERR_RSC_ID

Line 4280: FROM JTF_TERR_RSC_ACCESS_ALL JTRA

4276: AND (jtra.access_type = p_access_type OR p_access_type IS NULL);
4277: /*
4278: AND EXISTS (
4279: SELECT 1
4280: FROM JTF_TERR_RSC_ACCESS_ALL JTRA
4281: WHERE JTRA.terr_rsc_id = JTR.terr_rsc_id
4282: AND JTRA.trans_access_code IN ('ESC_OWNER', 'ESCALATION'));
4283: */
4284: