APPS.IEM_AMV_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

	select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
	from	amv_c_categories_vl
	where channel_category_name like '%'
	and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
	and	application_id = 520
	and	parent_channel_category_id is null
	order by channel_category_name;

Line: 206

	select count(*) into l_cat_count
	from	amv_c_categories_vl
	where channel_category_name like '%'
	and	 channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
	and	application_id = 520
	and	parent_channel_category_id = p_category_id
	order by channel_category_name;

Line: 216

		select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
		from	amv_c_categories_vl
		where channel_category_name like '%'
		and	 channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
		and	application_id = 520
		and	parent_channel_category_id = p_category_id
		order by channel_category_name;