1257:
1258: CURSOR c_category_set_id(p_category_id IN NUMBER,p_category_set_id IN NUMBER)IS
1259: SELECT b.category_set_id
1260: FROM mtl_default_category_sets a ,
1261: mtl_category_sets_b b ,
1262: mtl_categories_v c
1263: WHERE a.functional_area_id in (7,11)
1264: AND a.category_set_id = b.category_set_id
1265: AND b.structure_id = c.structure_id
1268:
1269: CURSOR c_get_category_set_id(p_category_id IN NUMBER)IS
1270: SELECT b.category_set_id
1271: FROM mtl_default_category_sets a ,
1272: mtl_category_sets_b b ,
1273: mtl_categories_v c
1274: WHERE a.functional_area_id in (7,11)
1275: AND a.category_set_id = b.category_set_id
1276: AND b.structure_id = c.structure_id