82: * check if there is any cst_quantiry_layers for this item
83: */
84: select count(*)
85: into row_count 86: from cst_quantity_layers 87: where organization_id = I_ORGANIZATION_ID
88: and inventory_item_id = I_INVENTORY_ITEM_ID
89: and ROWNUM < 2;
90: