APPS.EGO_CATG_MAP_UTIL_PKG dependencies on MTL_CATEGORIES_KFV

Line 14: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE;

10: )
11: IS
12:
13: --l_category_mapping_id NUMBER;
14: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE;
15: /*Bug 7184385, changed cursors to c_get_acc_category_id to get correct mapped target category and category_set id */
16:
17: /*
18: CURSOR c_get_category_mapping_id(cp_category_id NUMBER)

Line 62: from mtl_categories_kfv mck,

58: CLOSE c_get_catalog_id;*/
59:
60: /*Bug 7184385, changed select to get correct category_id passed a gpc_id */
61: select mck.category_id into l_category_id
62: from mtl_categories_kfv mck,
63: mtl_category_sets mcs,
64: mtl_default_category_sets_fk_v mdcs
65: where mdcs.functional_area_id = 21
66: and mdcs.category_set_id = mcs.category_set_id

Line 93: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE;

89: X_ICC_CATEGORY_ID OUT NOCOPY NUMBER
90: )
91: IS
92:
93: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE;
94:
95: CURSOR c_get_icc_category_id(cp_category_id NUMBER)
96: IS
97: SELECT

Line 110: FROM mtl_categories_kfv

106: BEGIN
107:
108: SELECT CATEGORY_ID
109: INTO l_category_id
110: FROM mtl_categories_kfv
111: WHERE SEGMENT2 = P_GPC_ID
112: AND ROWNUM = 1;
113:
114: OPEN c_get_icc_category_id(cp_category_id => l_category_id);