1075: and ( ( B.end_date_active is null ) OR ( B.end_date_active > sysdate ) )
1076: and ( ( A.end_date_active is not null ) AND ( A.end_date_active <= sysdate ) )
1077: and A.usage = 'ISUPPORT';
1078:
1079: Cursor l_del_chnl_csr (p_group_name amv_c_channels_vl.channel_name%TYPE ) IS
1080: select channel_id
1081: from amv_c_channels_vl
1082: where channel_name = p_group_name;
1083:
1077: and A.usage = 'ISUPPORT';
1078:
1079: Cursor l_del_chnl_csr (p_group_name amv_c_channels_vl.channel_name%TYPE ) IS
1080: select channel_id
1081: from amv_c_channels_vl
1082: where channel_name = p_group_name;
1083:
1084: Cursor l_del_mem_csr(p_group_id jtf_rs_group_members.group_id%TYPE )
1085: IS