APPS.EGO_CATG_MAP_UTIL_PKG dependencies on MTL_CATEGORIES_KFV
Line 55: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE;
51: X_ICC_CATEGORY_ID OUT NOCOPY NUMBER
52: )
53: IS
54: 55: l_category_id mtl_categories_kfv.CATEGORY_ID%TYPE; 56:
57: CURSOR c_get_icc_category_id(cp_category_id NUMBER)
58: IS
59: SELECT
Line 72: FROM mtl_categories_kfv
68: BEGIN
69:
70: SELECT CATEGORY_ID
71: INTO l_category_id 72: FROM mtl_categories_kfv 73: WHERE SEGMENT2 = P_GPC_ID
74: AND ROWNUM = 1;
75:
76: OPEN c_get_icc_category_id(cp_category_id => l_category_id);