The following lines contain the word 'select', 'insert', 'update' or 'delete':
select revision_status_code
from ahl_routes_app_v
where route_id = p_route_id;
select revision_status_code
from ahl_operations_b
where operation_id = p_operation_id;
-- Update route status from APPROVAL_REJECTED to DRAFT
OPEN get_oper_status (p_x_association_tbl(1).OBJECT_ID);
UPDATE ahl_operations_b
SET revision_status_code = 'DRAFT'
WHERE operation_id = p_x_association_tbl(1).OBJECT_ID;
-- Update route status from APPROVAL_REJECTED to DRAFT
OPEN get_route_status (p_x_association_tbl(1).OBJECT_ID);
UPDATE ahl_routes_b
SET revision_status_code = 'DRAFT'
WHERE route_id = p_x_association_tbl(1).OBJECT_ID;