DBA Data[Home] [Help]

APPS.AST_OFL_LEAD_ASSIGN_PARAM dependencies on JTF_RS_ROLES_B

Line 95: , Jtf_rs_roles_b rrb2

91: , (SELECT DISTINCT grpb.group_id
92: , rrb2.manager_flag
93: FROM Jtf_rs_groups_b grpb
94: , Jtf_rs_role_relations rrel2
95: , Jtf_rs_roles_b rrb2
96: , Jtf_rs_resource_extns rsc2
97: , Jtf_rs_group_members mem
98: , Fnd_user fnu
99: WHERE grpb.group_id = mem.group_id

Line 138: jtf_rs_roles_b rrb,

134: rsc.source_name flname
135: from jtf_rs_resource_extns rsc,
136: jtf_rs_group_members gmem,
137: jtf_rs_role_relations rrel,
138: jtf_rs_roles_b rrb,
139: (select distinct grpd.group_id
140: from jtf_rs_groups_denorm grpd,
141: jtf_rs_role_relations rrel2,
142: jtf_rs_roles_b rrb2,

Line 142: jtf_rs_roles_b rrb2,

138: jtf_rs_roles_b rrb,
139: (select distinct grpd.group_id
140: from jtf_rs_groups_denorm grpd,
141: jtf_rs_role_relations rrel2,
142: jtf_rs_roles_b rrb2,
143: jtf_rs_resource_extns rsc2,
144: jtf_rs_group_members mem,
145: fnd_user fnu
146: where grpd.parent_group_id = mem.group_id