APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 280: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

276: CURSOR territory_csr (l_fund_id NUMBER) IS
277: SELECT
278: j.terr_id territory_id
279: FROM
280: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
281: WHERE
282: fund.fund_id = l_fund_id
283: AND j.resource_id = fund.owner
284: -- AND j.primary_contact_flag = 'Y' ;

Line 2460: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

2456: CURSOR territory_csr (l_resource_id NUMBER) IS
2457: SELECT
2458: j.terr_id territory_id
2459: FROM
2460: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
2461: WHERE
2462: j.resource_id = l_resource_id
2463: -- AND j.primary_contact_flag = 'Y' ;
2464: AND j2.terr_rsc_id = j.terr_rsc_id

Line 5019: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

5015: CURSOR territory_csr (l_resource_id NUMBER) IS
5016: SELECT
5017: j.terr_id territory_id
5018: FROM
5019: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
5020: WHERE
5021: j.resource_id = l_resource_id
5022: -- AND j.primary_contact_flag = 'Y' ;
5023: AND j2.terr_rsc_id = j.terr_rsc_id

Line 6130: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

6126: CURSOR territory_csr (l_resource_id NUMBER) IS
6127: SELECT
6128: j.terr_id territory_id
6129: FROM
6130: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
6131: WHERE
6132: j.resource_id = l_resource_id
6133: -- AND j.primary_contact_flag = 'Y' ;
6134: AND j2.terr_rsc_id = j.terr_rsc_id

Line 7809: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

7805: CURSOR territory_csr (l_resource_id NUMBER) IS
7806: SELECT
7807: j.terr_id territory_id
7808: FROM
7809: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
7810: WHERE
7811: j.resource_id = l_resource_id
7812: -- AND j.primary_contact_flag = 'Y' ;
7813: AND j2.terr_rsc_id = j.terr_rsc_id