APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 207: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id

203:
204: UPDATE JTF_TTY_TERR_GRP_ACCTS
205: SET DN_JNR_ASSIGNED_FLAG = 'Y'
206: WHERE TERR_GROUP_ACCOUNT_ID IN
207: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
208: from jtf_tty_named_acct_rsc narsc
209: where assigned_flag = 'Y');
210:
211: UPDATE JTF_TTY_TERR_GRP_ACCTS

Line 208: from jtf_tty_named_acct_rsc narsc

204: UPDATE JTF_TTY_TERR_GRP_ACCTS
205: SET DN_JNR_ASSIGNED_FLAG = 'Y'
206: WHERE TERR_GROUP_ACCOUNT_ID IN
207: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
208: from jtf_tty_named_acct_rsc narsc
209: where assigned_flag = 'Y');
210:
211: UPDATE JTF_TTY_TERR_GRP_ACCTS
212: SET DN_JNR_ASSIGNED_FLAG = 'N'

Line 214: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id

210:
211: UPDATE JTF_TTY_TERR_GRP_ACCTS
212: SET DN_JNR_ASSIGNED_FLAG = 'N'
213: WHERE TERR_GROUP_ACCOUNT_ID NOT IN
214: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
215: from jtf_tty_named_acct_rsc narsc
216: where assigned_flag = 'Y');
217:
218:

Line 215: from jtf_tty_named_acct_rsc narsc

211: UPDATE JTF_TTY_TERR_GRP_ACCTS
212: SET DN_JNR_ASSIGNED_FLAG = 'N'
213: WHERE TERR_GROUP_ACCOUNT_ID NOT IN
214: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
215: from jtf_tty_named_acct_rsc narsc
216: where assigned_flag = 'Y');
217:
218:
219: delete from jtf_tty_admin_bin_summ