APPS.IEM_AMV_PVT dependencies on AMV_C_CATEGORIES_VL

Line 53: from amv_c_categories_vl

49: l_cat_ids_tbl.extend;
50: l_cat_names_tbl.extend;
51:
52: select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
53: from amv_c_categories_vl
54: where channel_category_name like '%'
55: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
56: and application_id = 520
57: and parent_channel_category_id is null

Line 207: from amv_c_categories_vl

203: l_cat_ids_tbl.extend;
204: l_cat_names_tbl.extend;
205:
206: select count(*) into l_cat_count
207: from amv_c_categories_vl
208: where channel_category_name like '%'
209: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
210: and application_id = 520
211: and parent_channel_category_id = p_category_id

Line 217: from amv_c_categories_vl

213:
214:
215: if (l_cat_count > 0) then
216: select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
217: from amv_c_categories_vl
218: where channel_category_name like '%'
219: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
220: and application_id = 520
221: and parent_channel_category_id = p_category_id