662: if (l_exp_item_flag <> 1) then
663: l_stmt_num := 45;
664: SELECT cost_group_id
665: INTO l_cost_group_id
666: FROM cst_quantity_layers
667: WHERE layer_id = i_layer_id;
668:
669: l_stmt_num := 48;
670: SELECT NVL(MIN(CQL.layer_id),-1)
668:
669: l_stmt_num := 48;
670: SELECT NVL(MIN(CQL.layer_id),-1)
671: INTO l_item_layer_id
672: FROM cst_quantity_layers CQL
673: WHERE CQL.inventory_item_id = i_inv_item_id
674: AND CQL.organization_id = i_org_id
675: AND CQL.cost_group_id = l_cost_group_id;
676: