APPS.OZF_TERR_LEVELS_PVT dependencies on JTF_TERR_ALL

Line 22: TYPE terrIdTbl IS TABLE OF jtf_terr_all.terr_id%TYPE;

18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19: g_bulk_limit CONSTANT NUMBER := 1000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
20:
21:
22: TYPE terrIdTbl IS TABLE OF jtf_terr_all.terr_id%TYPE;
23:
24:
25: /*---------------------------------------------------------------------
26: -- PROCEDURE

Line 219: FROM jtf_terr_all jtf

215: -- cursor to check uniqueness
216: CURSOR c_terr_id (l_terr_id IN NUMBER) IS
217: SELECT terr_id
218: ,territory_type_id
219: FROM jtf_terr_all jtf
220: WHERE jtf.terr_id = l_terr_id
221: AND jtf.parent_territory_id = 1;
222:
223:

Line 227: FROM jtf_terr_all jtf

223:
224: -- cursor to check territory type exists for each territory
225: CURSOR c_terr_type (l_terr_id IN NUMBER) IS
226: SELECT territory_type_id
227: FROM jtf_terr_all jtf
228: WHERE jtf.terr_id = l_terr_id;
229:
230: CURSOR c_level_value (p_hierarchy_id IN NUMBER, p_terr_type_id IN NUMBER) IS
231: SELECT olv.level_depth

Line 274: FROM jtf_terr_all

270: ,end_date_active
271: ,name
272: ,enabled_flag
273: -- Bug # 5723438 fixed by ateotia (-)
274: FROM jtf_terr_all
275:
276: -- 07/13/2001 mpande removed the where condition instead put a error message so that the user sets the
277: -- territory type properly
278: -- WHERE TERRITORY_TYPE_ID is not null

Line 552: FROM JTF_TERR_ALL JTR , JTF_TERR_USGS_ALL JTU , JTF_SOURCES_ALL JSE

548:
549: -- same as value set OZF_SRS_TERR_HIER_START_NODE used for concurrent program start node parameter
550: CURSOR c_get_all_root_nodes IS
551: SELECT JTR.TERR_ID
552: FROM JTF_TERR_ALL JTR , JTF_TERR_USGS_ALL JTU , JTF_SOURCES_ALL JSE
553: WHERE JTU.TERR_ID = JTR.TERR_ID
554: AND JTU.SOURCE_ID = JSE.SOURCE_ID
555: AND JTU.SOURCE_ID = -1003
556: AND JTR.PARENT_TERRITORY_ID = 1