APPS.ENI_DENORM_HRCHY dependencies on MTL_CATEGORIES_TL

Line 177: FROM MTL_CATEGORIES_TL

173: -- then the language code will be updated to NULL.
174: IF p_language_code IS NOT NULL THEN
175: BEGIN
176: SELECT 1 INTO l_count
177: FROM MTL_CATEGORIES_TL
178: WHERE CATEGORY_ID = p_child_id
179: AND SOURCE_LANG = p_language_code;
180:
181: l_language_code := p_language_code;

Line 258: FROM MTL_CATEGORIES_TL TL,

254: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y');
255:
256: CURSOR C3(l_child_id NUMBER, l_language VARCHAR2) IS
257: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
258: FROM MTL_CATEGORIES_TL TL,
259: (SELECT
260: CATEGORY_ID, LEVEL hrchy
261: FROM MTL_CATEGORY_SET_VALID_CATS
262: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id

Line 437: FROM MTL_CATEGORIES_TL TL,

433: WHERE B.CATEGORY_ID = D.CATEGORY_ID;
434:
435: CURSOR C3(l_child_id NUMBER, l_language VARCHAR2) IS
436: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
437: FROM MTL_CATEGORIES_TL TL,
438: (SELECT
439: CATEGORY_ID, LEVEL hrchy
440: FROM MTL_CATEGORY_SET_VALID_CATS
441: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id