APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CHANNELS_VL
Line 2605: from amv_c_channels_vl b
2601:
2602: CURSOR Get_CategoryChannels IS
2603: select b.channel_id
2604: , b.channel_name 2605: from amv_c_channels_vl b 2606: where b.channel_category_id = l_category_id
2607: and b.effective_start_date <= sysdate
2608: and nvl(b.expiration_date, sysdate) >= sysdate
2609: order by b.channel_name;