APPS.POS_COMPARE_REVISIONS dependencies on ICX_CAT_CATEGORIES_V

Line 5006: v_category_name icx_cat_categories_v.category_name%TYPE;

5002: ********************************************************************/
5003: FUNCTION get_shopping_category( p_category_id IN NUMBER )
5004: RETURN VARCHAR2 AS
5005:
5006: v_category_name icx_cat_categories_v.category_name%TYPE;
5007: v_progress varchar2(3);
5008:
5009: BEGIN
5010:

Line 5015: from icx_cat_categories_v

5011: v_progress := '111';
5012:
5013: select category_name
5014: INTO v_category_name
5015: from icx_cat_categories_v
5016: where rt_category_id = p_category_id
5017: and language = USERENV('LANG')
5018: and rownum = 1;
5019: