APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TERR_ALL

Line 87: from jtf_terr_all

83:
84: BEGIN
85: select geo_territory_id, terr_group_id
86: into l_geo_terr_id, l_terr_grp_id
87: from jtf_terr_all
88: where terr_id = p_terr_id;
89:
90: EXCEPTION
91: when FND_API.G_EXC_ERROR then

Line 171: from jtf_terr_all

167: , NUM_WINNERS
168: , 'GEOGRAPHY'
169: , DESCRIPTION
170: , 1
171: from jtf_terr_all
172: where terr_id = p_terr_id;
173:
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN

Line 214: from jtf_terr_all

210: , CREATED_BY
211: , CREATION_DATE
212: , LAST_UPDATED_BY
213: , LAST_UPDATE_DATE
214: from jtf_terr_all
215: where terr_id = p_terr_id;
216:
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN

Line 499: update jtf_terr_all

495: commit;
496:
497: BEGIN
498: --
499: update jtf_terr_all
500: set terr_group_id = l_terr_grp_id
501: , terr_group_flag = 'Y'
502: , catch_all_flag = 'N'
503: , geo_territory_id = l_geo_terr_id