APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_CATEGORIES_TL

Line 341: FROM icx_por_categories_tl cat

337: INTO xRtCategoryId
338: FROM icx_por_category_items ci
339: WHERE ci.rt_item_id = pRtItemId
340: AND EXISTS (SELECT 'primary category'
341: FROM icx_por_categories_tl cat
342: WHERE cat.rt_category_id = ci.rt_category_id
343: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)
344: AND ROWNUM = 1;
345: RETURN xRtCategoryId;

Line 1201: ICX_POR_CATEGORIES_TL cat

1197: gUpgradeUserId, gUpgradeUserId, sysdate
1198: FROM ICX_POR_ITEMS item,
1199: ICX_POR_ITEMS_TL tl,
1200: ICX_POR_CATEGORY_ITEMS ci,
1201: ICX_POR_CATEGORIES_TL cat
1202: WHERE item.rt_item_id = gIOldRtItemIds(i)
1203: AND item.rt_item_id = tl.rt_item_id
1204: AND ci.rt_item_id = item.rt_item_id
1205: AND cat.rt_category_id = ci.rt_category_id

Line 1365: FROM ICX_POR_CATEGORIES_TL cat

1361: SELECT gCIRtItemIds(i), cat.rt_category_id,
1362: gUpgradeUserId, gUpgradeUserId, sysdate,
1363: gUpgradeUserId, sysdate, gUpgradeUserId,
1364: gUpgradeUserId, gUpgradeUserId, sysdate
1365: FROM ICX_POR_CATEGORIES_TL cat
1366: WHERE cat.key = gCITemplateIds(i) || '_tmpl'
1367: AND cat.type = 3
1368: AND cat.language = (SELECT language_code
1369: FROM fnd_languages