DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_RS_ROLES_B

Line 131: jtf_rs_roles_b rol,

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
134: where narsc.resource_id = repmgr.resource_id
135: and narsc.rsc_group_id = repmgr.group_id

Line 220: jtf_rs_roles_b rol,

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
223: and narsc.rsc_group_id = repmgr.group_id
224: AND narsc.terr_group_account_id = tgaid

Line 1065: jtf_rs_roles_b rol,

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
1068: AND narsc.rsc_group_id = repmgr.group_id
1069: AND narsc.terr_group_account_id = c_tg_acct_id