APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_MY_DIRECTS_V

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 261: jtf_tty_my_directs_v mydir

257: FROM
258: jtf_tty_named_acct_rsc narsc,
259: jtf_tty_terr_grp_accts ga,
260: jtf_rs_rep_managers repmgr,
261: jtf_tty_my_directs_v mydir
262: WHERE narsc.resource_id = repmgr.resource_id
263: and narsc.rsc_group_id = repmgr.group_id
264: and repmgr.parent_resource_id = mydir.resource_id
265: and mydir.current_user_id = userid

Line 341: from jtf_tty_my_directs_v

337: current_user_id,
338: parent_group_id,
339: current_user_role_code,
340: current_user_rsc_id
341: from jtf_tty_my_directs_v
342: where CURRENT_USER_ID = to_number(p_userid);
343:
344: commit;
345:

Line 425: ' jtf_tty_my_directs_v mydir '||

421: ' FROM '||
422: ' jtf_tty_named_acct_rsc narsc, '||
423: ' jtf_tty_terr_grp_accts ga, '||
424: ' jtf_rs_rep_managers repmgr, '||
425: ' jtf_tty_my_directs_v mydir '||
426: ' WHERE narsc.resource_id = repmgr.resource_id '||
427: ' and narsc.rsc_group_id = repmgr.group_id '||
428: ' and repmgr.parent_resource_id = mydir.resource_id '||
429: ' and mydir.current_user_id = :0 '||

Line 448: ' jtf_tty_my_directs_v dir, '||

444: ' dir.resource_name, dir.resource_id, '||
445: ' dir.group_name, dir.group_id, '||
446: ' dir.role_name, dir.role_code '||
447: ' from '||
448: ' jtf_tty_my_directs_v dir, '||
449: ' jtf_tty_named_acct_rsc narsc, '||
450: ' jtf_tty_terr_grp_accts ga '||
451: ' where dir.current_user_id = :0 '||
452: ' and dir.resource_id = narsc.resource_id '||

Line 466: ' jtf_tty_my_directs_v dir '||

462: ' dir.resource_name, dir.resource_id,'||
463: ' dir.group_name, dir.group_id, '||
464: ' dir.role_name, dir.role_code '||
465: ' from '||
466: ' jtf_tty_my_directs_v dir '||
467: ' where dir.current_user_id = :0 '||
468: ' and dir.dir_user_id <> :1 '||
469: ' and dir.resource_id IN ( select res.parent_resource_id '||
470: ' from jtf_rs_rep_managers res, '||

Line 1054: from jtf_tty_my_directs_v mydir

1050: CURSOR c_direct_for_tg_account(c_tg_acct_id VARCHAR2, c_user_id NUMBER) IS
1051: select mydir.resource_id resource_id,
1052: mydir.group_id group_id,
1053: mydir.role_code role_code
1054: from jtf_tty_my_directs_v mydir
1055: where mydir.current_user_id = c_user_id
1056: and mydir.dir_user_id <> c_user_id
1057: and ( mydir.resource_id, mydir.group_id, mydir.role_code) in
1058: ( select /*+ NO_MERGE */