DBA Data[Home] [Help]

APPS.AMV_USER_PVT dependencies on AMV_U_MY_CHANNELS

Line 3643: From amv_u_my_channels

3639: And usg.usage = p_group_usage
3640: ;
3641: CURSOR Get_GroupChannelId(p_g_id IN NUMBER) IS
3642: Select subscribing_to_id channel_id
3643: From amv_u_my_channels
3644: Where user_or_group_id = p_g_id
3645: And user_or_group_type = G_GROUP_ARC_TYPE
3646: And subscribing_to_type = G_CHAN_ARC_TYPE
3647: And subscription_reason_type = 'ENFORCED'

Line 3928: Delete from amv_u_my_channels

3924: Delete from amv_u_access
3925: Where user_or_group_id = l_group_id
3926: And User_OR_group_type = G_GROUP_ARC_TYPE;
3927: --
3928: Delete from amv_u_my_channels
3929: Where user_or_group_id = l_group_id
3930: And User_OR_group_type = G_GROUP_ARC_TYPE;
3931:
3932: -- Remove channel from channels