72: l_user_name VARCHAR2(30);
73:
74: CURSOR c_grp_members(p_resource_id NUMBER) IS
75: SELECT group_id group_id, resource_id group_resource_id, 'INDIVIDUAL' resource_type
76: FROM jtf_rs_group_members
77: WHERE group_id = p_resource_id
78: AND delete_flag = 'N'
79: UNION
80: SELECT rgm.group_id group_id, rgr.group_id group_resource_id, 'GROUP' resource_type
77: WHERE group_id = p_resource_id
78: AND delete_flag = 'N'
79: UNION
80: SELECT rgm.group_id group_id, rgr.group_id group_resource_id, 'GROUP' resource_type
81: FROM jtf_rs_group_members rgm, jtf_rs_grp_relations rgr
82: WHERE rgm.group_id = rgr.related_group_id
83: AND rgm.group_id = p_resource_id
84: AND rgm.delete_flag = 'N'
85: AND rgr.delete_flag = 'N';