APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_MY_DIRECTS_GT

Line 91: jtf_tty_my_directs_gt mydir,

87: FROM (
88: SELECT mydir.role_code role_code,
89: COUNT(role_code) num
90: FROM
91: jtf_tty_my_directs_gt mydir,
92: (
93: select terr_grp_acct_id
94: from jtf_tty_webadi_interface
95: where user_id = userid

Line 133: jtf_tty_my_directs_gt dir

129: jtf_rs_rep_managers repmgr,
130: jtf_rs_role_relations rlt,
131: jtf_rs_roles_b rol,
132: jtf_rs_group_members grpmem,
133: jtf_tty_my_directs_gt dir
134: where narsc.resource_id = repmgr.resource_id
135: and narsc.rsc_group_id = repmgr.group_id
136: AND narsc.terr_group_account_id = tmp.terr_grp_acct_id
137: AND repmgr.par_role_relate_id = rlt.role_relate_id

Line 160: jtf_tty_my_directs_gt dir

156: narsc.rsc_group_id group_id,
157: narsc.rsc_role_code role_code
158: from jtf_tty_webadi_interface tmp,
159: jtf_tty_named_acct_rsc narsc,
160: jtf_tty_my_directs_gt dir
161: where narsc.terr_group_account_id = tmp.terr_grp_acct_id
162: AND dir.current_user_id = userid
163: AND dir.dir_user_id = userid
164: AND dir.resource_id = narsc.resource_id

Line 209: FROM jtf_tty_my_directs_gt /*jtf_tty_my_directs_v*/ mydir

205: select /* search directs */
206: mydir.resource_name, --mydir.resource_id,
207: mydir.group_name, --mydir.group_id,
208: mydir.role_name, mydir.role_code
209: FROM jtf_tty_my_directs_gt /*jtf_tty_my_directs_v*/ mydir
210: WHERE mydir.current_user_id = userid
211: and mydir.dir_user_id <> userid
212: and ( mydir.resource_id, mydir.group_id, mydir.role_code) in
213: ( select /*+ NO_MERGE */

Line 240: FROM jtf_tty_my_directs_gt /*jtf_tty_my_directs_v*/ mydir

236: SELECT
237: mydir.resource_name ,--mydir.resource_id,
238: mydir.group_name, --mydir.group_id,
239: mydir.role_name, mydir.role_code
240: FROM jtf_tty_my_directs_gt /*jtf_tty_my_directs_v*/ mydir
241: WHERE mydir.current_user_id = userid
242: and mydir.dir_user_id = userid
243: and ( mydir.resource_id, mydir.group_id, mydir.role_code) in
244: ( select /*+ NO_MERGE */

Line 314: delete from jtf_tty_my_directs_gt;

310: end;
311:
312:
313: /* build globle temp table */
314: delete from jtf_tty_my_directs_gt;
315: INSERT INTO jtf_tty_my_directs_gt
316: (
317: resource_id,
318: resource_name,

Line 315: INSERT INTO jtf_tty_my_directs_gt

311:
312:
313: /* build globle temp table */
314: delete from jtf_tty_my_directs_gt;
315: INSERT INTO jtf_tty_my_directs_gt
316: (
317: resource_id,
318: resource_name,
319: group_id,