DBA Data[Home] [Help]

APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CHANNELS_B

Line 923: from amv_c_channels_b

919: --
920:
921: CURSOR Get_CategoryChannels IS
922: select channel_id
923: from amv_c_channels_b
924: where channel_category_id = l_category_id;
925: --
926: BEGIN
927: -- Standard begin of API savepoint

Line 2226: from amv_c_channels_b

2222: and parent_channel_category_id = l_category_id;
2223:
2224: CURSOR Count_Channels_csr IS
2225: select count(channel_id)
2226: from amv_c_channels_b
2227: where channel_category_id = l_category_id;
2228: --
2229: BEGIN
2230: -- Standard begin of API savepoint

Line 3885: from amv_c_channels_b b

3881: --
3882: CURSOR Get_ChannelData IS
3883: select tl.channel_name
3884: , b.channel_category_id
3885: from amv_c_channels_b b
3886: , amv_c_channels_tl tl
3887: where b.channel_id = p_channel_id
3888: and b.channel_id = tl.channel_id
3889: and tl.language = userenv('lang');