DBA Data[Home] [Help]

APPS.AMV_MYCHANNEL_PVT dependencies on AMV_C_CATEGORIES_B

Line 1441: from amv_c_categories_b b1

1437: select channel_id
1438: from amv_c_channels_b
1439: where channel_category_id in (
1440: select b1.channel_category_id
1441: from amv_c_categories_b b1
1442: where b1.channel_category_id = p_category_id
1443: or b1.channel_category_id in (
1444: select b2.channel_category_id
1445: from amv_c_categories_b b2

Line 1445: from amv_c_categories_b b2

1441: from amv_c_categories_b b1
1442: where b1.channel_category_id = p_category_id
1443: or b1.channel_category_id in (
1444: select b2.channel_category_id
1445: from amv_c_categories_b b2
1446: where b2.parent_channel_category_id = p_category_id))
1447: and channel_type = AMV_UTILITY_PVT.G_CONTENT
1448: and access_level_type = AMV_UTILITY_PVT.G_PUBLIC;
1449: --