APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_CATEGORY_SETS_B

Line 152: From MTL_CATEGORY_SETS_B

148:
149: Sql_Stmt := 1;
150: Select STRUCTURE_ID
151: Into Old_Structure_id
152: From MTL_CATEGORY_SETS_B
153: WHERE CATEGORY_SET_ID = (select category_set_id
154: From MTL_DEFAULT_CATEGORY_SETS
155: Where FUNCTIONAL_AREA_ID = 2);
156:

Line 160: From MTL_CATEGORY_SETS_B

156:
157: Sql_Stmt := 3;
158: Select STRUCTURE_ID
159: Into New_Structure_id
160: From MTL_CATEGORY_SETS_B
161: WHERE CATEGORY_SET_ID = P_Category_Set_Id;
162:
163: If New_Structure_id <> Old_Structure_Id Then
164: Select count(*)

Line 312: From MTL_CATEGORY_SETS_B

308:
309: Sql_Stmt := 1;
310: Select STRUCTURE_ID
311: Into Old_Structure_id
312: From MTL_CATEGORY_SETS_B
313: WHERE CATEGORY_SET_ID = (select category_set_id
314: From MTL_DEFAULT_CATEGORY_SETS
315: Where FUNCTIONAL_AREA_ID = 5);
316:

Line 320: From MTL_CATEGORY_SETS_B

316:
317: Sql_Stmt := 3;
318: Select STRUCTURE_ID
319: Into New_Structure_id
320: From MTL_CATEGORY_SETS_B
321: WHERE CATEGORY_SET_ID = P_Category_Set_Id;
322:
323:
324: If New_Structure_id <> Old_Structure_Id Then

Line 695: FROM mtl_category_sets_b

691: sql_stmt := 1;
692:
693: SELECT structure_id
694: INTO old_structure_id
695: FROM mtl_category_sets_b
696: WHERE category_set_id = (SELECT category_set_id
697: FROM mtl_default_category_sets
698: WHERE functional_area_id = 19);
699:

Line 704: FROM mtl_category_sets_b

700: sql_stmt := 3;
701:
702: SELECT structure_id
703: INTO new_structure_id
704: FROM mtl_category_sets_b
705: WHERE category_set_id = P_Category_Set_Id;
706:
707: IF new_structure_id <> old_structure_id
708: THEN