APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on JTF_TTY_TERR_GROUPS

Line 161: , jtf_tty_terr_groups jtg

157: group by jga.terr_group_id) ASS,
158: ( select jga.terr_group_id, jtg.terr_group_name
159: , count(*) named_accounts
160: from jtf_tty_terr_grp_accts jga
161: , jtf_tty_terr_groups jtg
162: where jga.terr_group_id = jtg.terr_group_id
163: group by jga.terr_group_id, jtg.terr_group_name ) tot,
164: ( select
165: jga.terr_group_id

Line 221: select TERR_GROUP_ID from jtf_tty_terr_groups

217:
218:
219: delete from jtf_tty_admin_bin_summ
220: where TERR_GROUP_ID not in (
221: select TERR_GROUP_ID from jtf_tty_terr_groups
222: Where TRUNC(active_from_date) <= TRUNC(SYSDATE)
223: AND TRUNC(NVL(active_to_date, SYSDATE)) >= TRUNC(SYSDATE)
224: );
225:

Line 228: from jtf_tty_terr_groups jtg

224: );
225:
226: update jtf_tty_admin_bin_summ jtabs
227: set jtabs.TERR_GROUP_NAME = (select jtg.TERR_GROUP_NAME
228: from jtf_tty_terr_groups jtg
229: where jtg.TERR_GROUP_ID = jtabs.TERR_GROUP_ID);
230:
231:
232: insert into jtf_tty_admin_bin_summ jtabs

Line 249: from jtf_tty_terr_groups

245: , L_USER_ID
246: , L_SYSDATE
247: , L_USER_ID
248: , L_SYSDATE
249: from jtf_tty_terr_groups
250: where TERR_GROUP_ID not in
251: (select TERR_GROUP_ID
252: from jtf_tty_admin_bin_summ)
253: AND self_service_type = 'NAMED_ACCOUNT'