APPS.POS_COMPARE_REVISIONS dependencies on ICX_CAT_CATEGORIES_V

Line 5000: v_category_name icx_cat_categories_v.category_name%TYPE;

4996: ********************************************************************/
4997: FUNCTION get_shopping_category( p_category_id IN NUMBER )
4998: RETURN VARCHAR2 AS
4999:
5000: v_category_name icx_cat_categories_v.category_name%TYPE;
5001: v_progress varchar2(3);
5002:
5003: BEGIN
5004:

Line 5009: from icx_cat_categories_v

5005: v_progress := '111';
5006:
5007: select category_name
5008: INTO v_category_name
5009: from icx_cat_categories_v
5010: where rt_category_id = p_category_id
5011: and language = USERENV('LANG')
5012: and rownum = 1;
5013: