APPS.CSTPPCLM dependencies on CST_PAC_QUANTITY_LAYERS

Line 60: FROM cst_pac_quantity_layers

56: -- and to get maximum quantity_layer_id
57: -- included count condition
58: CURSOR c_cpql_quantity_layer IS
59: SELECT COUNT(quantity_layer_id), MAX(quantity_layer_id)
60: FROM cst_pac_quantity_layers
61: WHERE pac_period_id = i_pac_period_id
62: AND inventory_item_id = i_item_id
63: AND cost_group_id = i_cost_group_id
64: GROUP BY quantity_layer_id;

Line 229: ** should create it in cst_pac_item_costs and cst_pac_quantity_layers

225: IF ( l_cost_layer_id = 0) THEN
226: l_stmt_num := 20;
227: /*
228: ** if the cost_layer_id is 0, then the layer doesn't exist, so we
229: ** should create it in cst_pac_item_costs and cst_pac_quantity_layers
230: */
231: SELECT cst_pac_item_costs_s.nextval
232: INTO l_cost_layer_id
233: FROM dual;

Line 236: SELECT bom.cst_pac_quantity_layers_s.nextval

232: INTO l_cost_layer_id
233: FROM dual;
234:
235: l_stmt_num := 30;
236: SELECT bom.cst_pac_quantity_layers_s.nextval
237: INTO l_quantity_layer_id
238: FROM dual;
239:
240: l_stmt_num := 40;

Line 370: INSERT INTO cst_pac_quantity_layers (

366:
367: );
368:
369: l_stmt_num := 60;
370: INSERT INTO cst_pac_quantity_layers (
371: quantity_layer_id,
372: cost_layer_id,
373: pac_period_id,
374: inventory_item_id,