APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_OPERATIONS_B

Line 2137: from ahl_operations_b

2133:
2134: cursor get_oper_status (p_operation_id in number)
2135: is
2136: select revision_status_code
2137: from ahl_operations_b
2138: where operation_id = p_operation_id;
2139:
2140: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2141: IS

Line 2360: UPDATE ahl_operations_b

2356: OPEN get_oper_status (p_object_id);
2357: FETCH get_oper_status INTO l_obj_status;
2358: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2359: THEN
2360: UPDATE ahl_operations_b
2361: SET revision_status_code = 'DRAFT'
2362: WHERE operation_id = p_object_id;
2363: END IF;
2364: CLOSE get_oper_status;