APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 91: jtf_terr_rsc_access_all jtraa

87: --R12 - Modified for Primary Contact - bug 4643041
88: CURSOR c_get_terr_owner IS
89: SELECT resource_id
90: FROM jtf_terr_rsc_all jtra,
91: jtf_terr_rsc_access_all jtraa
92: WHERE jtraa.terr_rsc_id = jtra.terr_rsc_id
93: AND jtraa.access_type = 'OFFER'
94: AND jtraa.trans_access_code = 'PRIMARY_CONTACT'
95: -- WHERE primary_contact_flag = 'Y'

Line 910: jtf_terr_rsc_access_all jtraa

906: --R12 - Modified for Primary Contact - bug 4643041
907: CURSOR c_get_territory_resource(p_terr_id NUMBER, p_primary_flag VARCHAR2) IS
908: SELECT jtra.resource_id, jtra.resource_type
909: FROM jtf_terr_rsc_all jtra,
910: jtf_terr_rsc_access_all jtraa
911: -- WHERE primary_contact_flag = p_primary_flag
912: WHERE jtraa.terr_rsc_id = jtra.terr_rsc_id
913: AND jtraa.access_type = 'OFFER'
914: AND DECODE(jtraa.trans_access_code,'PRIMARY_CONTACT','Y','NONE','N','DEFAULT','N','N')=p_primary_flag