DBA Data[Home] [Help]

APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_CATEGORY_SETS_B

Line 147: From MTL_CATEGORY_SETS_B

143:
144: Sql_Stmt := 1;
145: Select STRUCTURE_ID
146: Into Old_Structure_id
147: From MTL_CATEGORY_SETS_B
148: WHERE CATEGORY_SET_ID = (select category_set_id
149: From MTL_DEFAULT_CATEGORY_SETS
150: Where FUNCTIONAL_AREA_ID = 2);
151:

Line 155: From MTL_CATEGORY_SETS_B

151:
152: Sql_Stmt := 3;
153: Select STRUCTURE_ID
154: Into New_Structure_id
155: From MTL_CATEGORY_SETS_B
156: WHERE CATEGORY_SET_ID = P_Category_Set_Id;
157:
158: If New_Structure_id <> Old_Structure_Id Then
159: Select count(*)

Line 307: From MTL_CATEGORY_SETS_B

303:
304: Sql_Stmt := 1;
305: Select STRUCTURE_ID
306: Into Old_Structure_id
307: From MTL_CATEGORY_SETS_B
308: WHERE CATEGORY_SET_ID = (select category_set_id
309: From MTL_DEFAULT_CATEGORY_SETS
310: Where FUNCTIONAL_AREA_ID = 5);
311:

Line 315: From MTL_CATEGORY_SETS_B

311:
312: Sql_Stmt := 3;
313: Select STRUCTURE_ID
314: Into New_Structure_id
315: From MTL_CATEGORY_SETS_B
316: WHERE CATEGORY_SET_ID = P_Category_Set_Id;
317:
318:
319: If New_Structure_id <> Old_Structure_Id Then