APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_RS_REP_MANAGERS

Line 102: from jtf_rs_rep_managers repmgr,

98: mydir.current_user_id = userid
99: and mydir.resource_id in (
100: select -- NO_MERGE
101: repmgr.parent_resource_id
102: from jtf_rs_rep_managers repmgr,
103: jtf_tty_named_acct_rsc narsc,
104: jtf_tty_terr_grp_accts ga
105: where narsc.resource_id = repmgr.resource_id
106: and narsc.rsc_group_id = repmgr.group_id

Line 129: jtf_rs_rep_managers repmgr,

125: grpmem.group_id group_id,
126: rol.role_code role_code
127: from jtf_tty_webadi_interface tmp,
128: jtf_tty_named_acct_rsc narsc,
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

Line 218: jtf_rs_rep_managers repmgr,

214: repmgr.parent_resource_id,
215: grpmem.group_id,
216: rol.role_code
217: from jtf_tty_named_acct_rsc narsc,
218: jtf_rs_rep_managers repmgr,
219: jtf_rs_role_relations rlt,
220: jtf_rs_roles_b rol,
221: jtf_rs_group_members grpmem
222: where narsc.resource_id = repmgr.resource_id

Line 260: jtf_rs_rep_managers repmgr,

256: mydir.role_name, mydir.role_code
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

Line 424: ' jtf_rs_rep_managers repmgr, '||

420: ' dir.role_name, dir.role_code '||
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 '||

Line 470: ' from jtf_rs_rep_managers res, '||

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, '||
471: ' jtf_tty_named_acct_rsc narsc, '||
472: ' jtf_tty_terr_grp_accts ga '||
473: ' where res.resource_id = narsc.resource_id '||
474: ' and res.group_id = narsc.rsc_group_id '||

Line 1063: jtf_rs_rep_managers repmgr,

1059: repmgr.parent_resource_id,
1060: grpmem.group_id,
1061: rol.role_code
1062: from jtf_tty_named_acct_rsc narsc,
1063: jtf_rs_rep_managers repmgr,
1064: jtf_rs_role_relations rlt,
1065: jtf_rs_roles_b rol,
1066: jtf_rs_group_members grpmem
1067: where narsc.resource_id = repmgr.resource_id