APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on JTF_TERR_RSC_ALL

Line 261: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

257: CURSOR territory_csr (l_fund_id NUMBER) IS
258: SELECT
259: j.terr_id territory_id
260: FROM
261: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
262: WHERE
263: fund.fund_id = l_fund_id
264: AND j.resource_id = fund.owner
265: -- AND j.primary_contact_flag = 'Y' ;

Line 2437: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

2433: CURSOR territory_csr (l_resource_id NUMBER) IS
2434: SELECT
2435: j.terr_id territory_id
2436: FROM
2437: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
2438: WHERE
2439: j.resource_id = l_resource_id
2440: -- AND j.primary_contact_flag = 'Y' ;
2441: AND j2.terr_rsc_id = j.terr_rsc_id

Line 4992: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

4988: CURSOR territory_csr (l_resource_id NUMBER) IS
4989: SELECT
4990: j.terr_id territory_id
4991: FROM
4992: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
4993: WHERE
4994: j.resource_id = l_resource_id
4995: -- AND j.primary_contact_flag = 'Y' ;
4996: AND j2.terr_rsc_id = j.terr_rsc_id

Line 6101: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

6097: CURSOR territory_csr (l_resource_id NUMBER) IS
6098: SELECT
6099: j.terr_id territory_id
6100: FROM
6101: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
6102: WHERE
6103: j.resource_id = l_resource_id
6104: -- AND j.primary_contact_flag = 'Y' ;
6105: AND j2.terr_rsc_id = j.terr_rsc_id

Line 7778: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

7774: CURSOR territory_csr (l_resource_id NUMBER) IS
7775: SELECT
7776: j.terr_id territory_id
7777: FROM
7778: jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
7779: WHERE
7780: j.resource_id = l_resource_id
7781: -- AND j.primary_contact_flag = 'Y' ;
7782: AND j2.terr_rsc_id = j.terr_rsc_id