[Home] [Help]
472: -- Cursor for selecting route_operation_association_id.
473: CURSOR get_route_oper_id(c_operation_step NUMBER, c_operation_number VARCHAR2, c_operation_status VARCHAR2, c_route_id NUMBER)
474: IS
475: SELECT route_operation_id
476: FROM ahl_route_operations ro,ahl_operations_vl op
477: WHERE ro.operation_id = op.operation_id
478: AND ro.route_id = c_route_id
479: AND ro.step = c_operation_step
480: AND op.concatenated_segments = c_operation_number