19: AND rownum = 1;
20:
21: CURSOR validate_formula(vFormula_id NUMBER) IS
22: SELECT 1
23: FROM fm_form_mst_b
24: WHERE formula_id = vformula_id
25: AND delete_mark = 0
26: AND formula_status <> 1000;
27:
26: AND formula_status <> 1000;
27:
28: CURSOR get_formula_no_vers(vFormula_id NUMBER) IS
29: SELECT formula_no, Formula_vers
30: FRom fm_form_mst_b
31: WHERE FORMULA_id = vFormula_id;
32:
33: Cursor get_item_info(vItem_id NUMBER) IS
34: SELECT concatenated_segments, primary_uom_code