APPS.AMV_MYCHANNEL_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1186: from jtf_rs_group_members

1182: , notify_flag
1183: , notification_interval_type
1184: from amv_u_my_channels
1185: where user_or_group_id in (select group_id
1186: from jtf_rs_group_members
1187: where resource_id = p_user_id and
1188: delete_flag = 'N')
1189: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP;
1190:

Line 2001: from jtf_rs_group_members

1997: CURSOR Get_MyChannels IS
1998: select subscribing_to_id
1999: from amv_u_my_channels
2000: where user_or_group_id in (select group_id
2001: from jtf_rs_group_members
2002: where resource_id = p_user_id)
2003: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2004: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2005: union

Line 2017: from jtf_rs_group_members

2013: CURSOR Get_MyCategories IS
2014: select subscribing_to_id
2015: from amv_u_my_channels
2016: where user_or_group_id in (select group_id
2017: from jtf_rs_group_members
2018: where resource_id = p_user_id
2019: and delete_flag <> 'Y')
2020: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2021: and subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY

Line 2038: from jtf_rs_group_members

2034: , jtf_amv_items_vl ib
2035: where cim.channel_id in (select subscribing_to_id
2036: from amv_u_my_channels
2037: where user_or_group_id in (select group_id
2038: from jtf_rs_group_members
2039: where resource_id = p_user_id)
2040: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2041: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2042: union

Line 2063: from jtf_rs_group_members

2059: , jtf_amv_items_vl ib
2060: where cim.channel_id in (select subscribing_to_id
2061: from amv_u_my_channels
2062: where user_or_group_id in (select group_id
2063: from jtf_rs_group_members
2064: where resource_id = p_user_id)
2065: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2066: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2067: union