DBA Data[Home] [Help]

APPS.IBU_DYN_USER_GROUPS_PKG dependencies on AMV_C_CHANNELS_VL

Line 1079: Cursor l_del_chnl_csr (p_group_name amv_c_channels_vl.channel_name%TYPE ) IS

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:

Line 1081: from amv_c_channels_vl

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