APPS.AHL_RM_ASSO_DOCASO_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 81

select revision_status_code
from ahl_routes_app_v
where route_id = p_route_id;

Line: 89

select revision_status_code
from ahl_operations_b
where operation_id = p_operation_id;

Line: 298

		-- Update route status from APPROVAL_REJECTED to DRAFT
		OPEN get_oper_status (p_x_association_tbl(1).OBJECT_ID);

Line: 303

			UPDATE ahl_operations_b
			SET revision_status_code = 'DRAFT'
			WHERE operation_id = p_x_association_tbl(1).OBJECT_ID;

Line: 345

		-- Update route status from APPROVAL_REJECTED to DRAFT
  		OPEN get_route_status (p_x_association_tbl(1).OBJECT_ID);

Line: 350

			UPDATE ahl_routes_b
			SET revision_status_code = 'DRAFT'
			WHERE route_id = p_x_association_tbl(1).OBJECT_ID;