APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 182: from jtf_rs_group_members mem,

178:
179: cursor c_groups_manager(cl_current_user_id number, cl_eff_resource_id number
180: ) is
181: Select mem.resource_id, mem.group_id, rol.role_code
182: from jtf_rs_group_members mem,
183: jtf_rs_role_relations rlt,
184: jtf_rs_roles_b rol,
185: jtf_rs_group_members cgrpmem,
186: jtf_rs_resource_extns crsc,

Line 185: jtf_rs_group_members cgrpmem,

181: Select mem.resource_id, mem.group_id, rol.role_code
182: from jtf_rs_group_members mem,
183: jtf_rs_role_relations rlt,
184: jtf_rs_roles_b rol,
185: jtf_rs_group_members cgrpmem,
186: jtf_rs_resource_extns crsc,
187: jtf_rs_groups_denorm grpden
188: where crsc.user_id = cl_current_user_id
189: and crsc.resource_id = cgrpmem.resource_id

Line 205: from jtf_rs_group_members grv1

201: and rlt.role_resource_id = mem.group_member_id
202: and mem.delete_flag = 'N'
203: and mem.group_id = grpden.parent_group_id
204: and grpden.group_id IN ( select grv1.group_id
205: from jtf_rs_group_members grv1
206: where grv1.resource_id = cl_eff_resource_id );
207:
208:
209:

Line 603: from jtf_rs_group_members grv1

599: WHERE ar.resource_id = grv.resource_id
600: and grpd.parent_group_id = grv.parent_group_id
601: and exists (
602: select 1
603: from jtf_rs_group_members grv1
604: where grpd.group_id = grv1.group_id
605: and grv1.resource_id = lp_resource_id )
606: and grv.CURRENT_USER_ID = l_user_id )
607: and rownum < 2;