APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CHL_ITEM_MATCH

Line 1091: DELETE FROM amv_c_chl_item_match

1087: AMV_C_CHANNELS_PKG.DELETE_ROW( l_channel_id);
1088: END LOOP;
1089: CLOSE Get_CategoryChannels;
1090: -- Remove channel item matches
1091: DELETE FROM amv_c_chl_item_match
1092: WHERE channel_category_id = l_category_id;
1093:
1094: -- Remove category from my channels
1095: DELETE FROM amv_u_my_channels

Line 2832: from amv_c_chl_item_match cim

2828:
2829: CURSOR Get_CategoryItems_csr IS
2830: select ib.item_id
2831: , ib.item_name
2832: from amv_c_chl_item_match cim
2833: , jtf_amv_items_vl ib
2834: where cim.channel_category_id = l_category_id
2835: and cim.channel_id is null
2836: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

Line 3070: from amv_c_chl_item_match cim

3066:
3067: CURSOR Get_CategoryItems_csr IS
3068: select ib.item_id
3069: , ib.item_name
3070: from amv_c_chl_item_match cim
3071: , jtf_amv_items_vl ib
3072: where cim.channel_category_id = l_category_id
3073: and cim.channel_id is null
3074: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

Line 3084: from amv_c_chl_item_match cim

3080: order by l_sort_col ||' '||l_sort_dir;
3081:
3082: CURSOR Get_ItemsTotal_csr IS
3083: select count(cim.item_id)
3084: from amv_c_chl_item_match cim
3085: , jtf_amv_items_vl ib
3086: where cim.channel_category_id = l_category_id
3087: and cim.channel_id is null
3088: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED