580: Cursor CurGetOperSeq(c_Oper_seq number,c_work_id number)
581: Is
582: /*
583: Select workorder_operation_id, department_id, department_code
584: from ahl_workorder_operations_v
585: where operation_sequence_num=c_oper_seq
586: and workorder_id=c_work_id;
587: */
588:
1500:
1501: cursor get_operation_rec(c_operation_id NUMBER)
1502: is
1503: SELECT *
1504: FROM AHL_WORKORDER_OPERATIONS_V
1505: WHERE workorder_operation_id=c_operation_id;
1506:
1507: l_operation_rec get_operation_rec%ROWTYPE;
1508: