DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 137: , jtf_rs_group_members mem

133: , rlt.start_date_active
134: , rlt.end_date_active
135: , rlt.object_version_number
136: FROM jtf_rs_role_relations rlt
137: , jtf_rs_group_members mem
138: WHERE mem.resource_id = l_resource_id
139: AND nvl(mem.delete_flag, 'N') <> 'Y'
140: AND rlt.role_resource_id = mem.group_member_id
141: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 625: jtf_rs_group_members a

621: SELECT '1'
622: INTO l_mgr
623: FROM jtf_rs_roles_b c,
624: jtf_rs_role_relations b,
625: jtf_rs_group_members a
626: WHERE a.group_id = parent_grp_rec.parent_group_id
627: AND a.resource_id = l_resource_id
628: AND nvl(a.delete_flag, 'N') <> 'Y'
629: AND b.role_resource_id = a.group_member_id

Line 654: jtf_rs_group_members a

650: SELECT '2'
651: INTO l_mgr
652: FROM jtf_rs_roles_b c,
653: jtf_rs_role_relations b,
654: jtf_rs_group_members a
655: WHERE a.group_id = p_group_id
656: AND a.resource_id = l_resource_id
657: AND nvl(a.delete_flag, 'N') <> 'Y'
658: AND b.role_resource_id = a.group_member_id

Line 781: jtf_rs_group_members mem

777: rlt.start_date_active,
778: rlt.end_date_active,
779: rlt.object_version_number
780: FROM jtf_rs_role_relations rlt,
781: jtf_rs_group_members mem
782: WHERE mem.group_id = c_group_id
783: AND nvl(mem.delete_flag, 'N') <> 'Y'
784: AND rlt.role_resource_id = mem.group_member_id
785: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'