DBA Data[Home] [Help]

APPS.QA_ERES_PKG dependencies on MTL_CATEGORIES_KFV

Line 60: FROM mtl_categories_kfv MCK, MTL_CATEGORY_SETS_B CSET

56: IS
57: x_name varchar2(240) := null;
58: CURSOR c IS
59: SELECT MCK.concatenated_segments
60: FROM mtl_categories_kfv MCK, MTL_CATEGORY_SETS_B CSET
61: WHERE CSET.CATEGORY_SET_ID = p_category_set_id AND
62: MCK.STRUCTURE_ID = CSET.STRUCTURE_ID AND
63: MCK.CATEGORY_ID = p_category_id;
64: BEGIN