APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CATEGORIES_TL

Line 261: from amv_c_categories_b b, amv_c_categories_tl tl

257: l_category_id number;
258: --
259: CURSOR Get_CategoryId is
260: select b.channel_category_id
261: from amv_c_categories_b b, amv_c_categories_tl tl
262: where tl.channel_category_name = p_category_name
263: and tl.language = userenv('lang')
264: and tl.channel_category_id = b.channel_category_id
265: and b.parent_channel_category_id is null;

Line 269: from amv_c_categories_b b, amv_c_categories_tl tl

265: and b.parent_channel_category_id is null;
266: --
267: CURSOR Get_SubCategoryId is
268: select b.channel_category_id
269: from amv_c_categories_b b, amv_c_categories_tl tl
270: where tl.channel_category_name = p_category_name
271: and tl.language = userenv('lang')
272: and tl.channel_category_id = b.channel_category_id
273: and b.parent_channel_category_id = p_parent_category_id;

Line 333: from amv_c_categories_tl

329: l_category_name varchar2(80);
330: --
331: CURSOR Get_CategoryName IS
332: select channel_category_name
333: from amv_c_categories_tl
334: where channel_category_id = p_category_id
335: and language = userenv('lang');
336: BEGIN
337: IF p_category_id = FND_API.G_MISS_NUM OR

Line 392: from amv_c_categories_b A, amv_c_categories_tl B

388: l_temp_cat_name varchar2(80);
389: --
390: cursor scat_id is
391: select A.channel_category_id, channel_category_name
392: from amv_c_categories_b A, amv_c_categories_tl B
393: where parent_channel_category_id = l_cat_id
394: and A.channel_category_id = B.channel_category_id
395: and B.language = USERENV('LANG')
396: order by channel_category_name;

Line 1236: FROM amv_c_categories_b b, amv_c_categories_tl tl

1232: l_category_array AMV_NUMBER_VARRAY_TYPE;
1233:
1234: CURSOR Get_CategoryOrder IS
1235: SELECT b.channel_category_id
1236: FROM amv_c_categories_b b, amv_c_categories_tl tl
1237: WHERE b.parent_channel_category_id is null
1238: and b.application_id = p_application_id
1239: ORDER BY tl.channel_category_name;
1240:

Line 1243: FROM amv_c_categories_b b, amv_c_categories_tl tl

1239: ORDER BY tl.channel_category_name;
1240:
1241: CURSOR Get_SubCategoryOrder IS
1242: SELECT b.channel_category_id
1243: FROM amv_c_categories_b b, amv_c_categories_tl tl
1244: WHERE b.parent_channel_category_id = l_parent_category_id
1245: ORDER BY tl.channel_category_name;
1246:
1247: CURSOR Get_CatRec_csr IS

Line 1770: from amv_c_categories_tl

1766: where channel_category_id = l_category_id;
1767:
1768: CURSOR Get_CatDesc_csr IS
1769: select description
1770: from amv_c_categories_tl
1771: where channel_category_id = l_category_id
1772: and language = userenv('lang');
1773:
1774: --